JDBC方式连接mysql
1)向DriverManager注册数据库
a.添加数据库jar包:项目右键------->Build Path ------->Add External Archives
b.创建driver实例:Class.forName("com.mysql.jdbc.Driver").newInstance();
2)定义Connection对象:Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/数据库名","用户名","密码");
3)执行 Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("sql语句");//查询并放入结果集
stmt.executeUpdate("sql语句");//增删改
4)关闭资源close()