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();