一,在jdbc中使用增删改查并连接mysql
步骤:
String url="jdbc:mysql://localost:3306/learn";//learn数据库名字
String username="root";
String password="123456";
String sql="insert into user(name,age,sex) values('小王','12','男')";
String sql1="update user set age=13 where name='小红'";
(1)加载驱动
Class.forName("com.mysql.jdbc.Driver")
(2)得到Connection
Connection conn=
DriverManager.getConnection(url,username,password);
(3)获得PreparedStatement
Statement st=conn.createStatement();//记得导入的包是java.sql.Statement
(4)获得ResultSet---查询单独列
boolean rs1= st.execute("insert into user(name,age,sex) values('小王','男','12')");
(5)关闭事务
st.close();
conn.close();
三,JDBC查询操作
步骤:
String url="jdbc:mysql://localost:3306/learn";//learn数据库名字
String username="root";
String password="123456";
(1)加载驱动
Class.forName("com.mysql.jdbc.Driver")
(2)得到Connection
Connection conn=
DriverManager.getConnection(url,username,password);
(3)获得PreparedStatement
Statement st=conn.createStatement();//记得导入的包是java.sql.Statement
ResultSet rs1=st.executeQuery(sql1);
(4)获得ResultSet
ResultSet rs1=st.executeQuery(sql1);
while(rs1.next()) {
int name1=rs1.getInt("age");//表的属性。从sql查询出的所有值中获取age的值;
String name2=rs1.getString("name");//表的属性。从sql查询出的所有值中获取name的值;
System.out.println(name1); }
(5)关闭事务
rs1.close();
st.close();
conn.close();