MySQL数据库JDBC连接基本步骤

      在Java程序中通过JDBC连接数据库一般有以下几个步骤：

        1.加载数据库提供的驱动

Class.forName("com.mysql.jdbc.Driver");

        2.获取数据库连接对象

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/university", "root", "123456");

        3. 获取处理命令（用于sql语句）

Statement stmt = conn.createStatement();

      4.发送sql命令         

stmt.execute("create table user(id int primary key auto_increment,userName varchar(32),password varchar(64))");         stmt.execute("insert into user(id,userName,password) values(1,'root','123456')");

     5.获取处理结果      

ResultSet result = stmt.executeQuery("select * from user "); System.out.println("id\tuserName\tpassword"); while(result.next()){ System.out.print(result.getInt(1)+"\t"); System.out.print(result.getString(2)+"\t"); System.out.print(result.getString(3)+"lt"); System.out.println(); ResultSet result = stmt.executeQuery("select * from user "); System.out.println("id\tuserName\tpassword"); while(result.next()){ System.out.print(result.getInt(1)+"\t"); System.out.print(result.getString(2)+"\t"); System.out.print(result.getString(3)+"lt"); System.out.println();