JDBC连接mysql数据库

今天我学习了如何使用JDBC来连接mysql数据库。
查询数据库
1.导入jar包
2.加载驱动

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

3.建立连接数据库对象

conn=DriverManager.getConnection("jdbc:mysql:///test","root","root"); 

4.定义sql语句

String sql="select * from student";

5.创建执行sql语句对象

stat=conn.createStatement();

6.建立结果集对象存放查询结果

rs=stat.executeQuery(sql); 

7.遍历结果集 输出结果

​while (rs.next()){
   String name=rs.getString(1);
   String sex=rs.getString(2);
   System.out.println(name);
   System.out.println(sex);
}

8.关闭资源

if (rs!=null){

       try {

           rs.close);

       } catch (SQLException e) {

           e.printStackTrace();

       }

   }

   if (stat!=null){

       try {

           stat.close();

       } catch (SQLException e) {

           e.printStackTrace();

       }

   }

   if (conn!=null){

       try {

           conn.close();

       } catch (SQLException e) {

           e.printStackTrace();

       }

   }

}

完整代码
private static void demo3() {
Connection conn = null;
Statement stat=null;
ResultSet rs=null;
try {
Class.forName(“com.mysql.jdbc.Driver”);
conn = DriverManager.getConnection(“jdbc:mysql:///test”, “root”, “root”);
String sql = “select * from student”;
stat = conn.createStatement();
rs = stat.executeQuery(sql);
while (rs.next()) {
String name = rs.getString(1);
String sex = rs.getString(2);
System.out.println(name + “==” + sex);
}

    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (stat != null) {
            try {
                stat.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

    }
}

增删改数据库
1.导入jar包
2.加载驱动

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

3.创建数据库连接对象

conn = DriverManager.getConnection("jdbc:mysql:///test", "root", "root");

4.定义sql语句

String sql = "Update student set sex='男' where name='123456'"; //可以更换sql语句

5.定义计数器计算stat对象执行sql语句的数量

int count = stat.executeUpdate(sql); 

6.关闭资源

 if (stat != null) {
                try {
                    stat.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
 if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

完整代码
private static void demo2() {
Connection conn = null;
Statement stat = null;
try {
Class.forName(“com.mysql.jdbc.Driver”);
conn = DriverManager.getConnection(“jdbc:mysql:///test”, “root”, “root”);
String sql = “Update student set sex=‘男’ where name=‘123456’”;
stat = conn.createStatement();
int count = stat.executeUpdate(sql);
//System.out.println(count);
if (count > 0) {
System.out.println(“执行成功”);
} else {
System.out.println(“执行失败”);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (stat != null) {
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}