java代码连接mysql的两种方式

方式1

package com.shujia.mysql; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class MsyqlTest2 { public static void main(String[] args) throws Exception { //1.反射记载Driver Class.forName("com.mysql.jdbc.Driver"); //2.创建连接 Connection conn = DriverManager.getConnection("jdbc:mysql://master:3306/shujia", "root", "123456"); //3.1创建执行器 首先加载sql的格式 // 使用PreparedStatement执行器执行sql时，参数通过？进行传递 String sql ="select * from student where id = ?"; PreparedStatement ps = conn.prepareStatement(sql); //通过ps。set数据类型(index,value)进行赋值 ps.setString(1,"1056"); //3.2通过执行器执行sql获取结果集 ResultSet rs = ps.executeQuery();//执行sql语句 回去结果集 //4.解析结果集 while (rs.next()){ int id = rs.getInt("id"); String name = rs.getString("name"); int age = rs.getInt("age"); String sex = rs.getString("sex"); System.out.println(id+"-"+name+"-"+age+"-"+sex); } rs.close(); ps.close(); conn.close(); } }

方式2

package com.shujia.mysql; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; //创建Statement步骤 public class MysqlTest { public static void main(String[] args)throws Exception { //1.反射加载Driver Class.forName("com.mysql.jdbc.Driver"); //2.创建连接 Connection conn = DriverManager.getConnection("jdbc:mysql://master:3306/shujia", "root", "123456"); //3.1创建执行器 Statement statement = conn.createStatement(); //3.2执行器执行sql语句 获得ResultSet结果集 String sql="select * from student"; ResultSet rs = statement.executeQuery(sql); //4.解析结果 while(rs.next()){ int id = rs.getInt("id"); String name = rs.getString("name"); int age = rs.getInt("age"); String sex = rs.getString("sex"); System.out.println(id+"-"+name+"-"+age+"-"+sex); } rs.close(); statement.close(); conn.close(); } }