package cn.itcast.jdbc;
import java.sql.*;
public class JdbcDemo01 {
public static void main(String[] args) throws SQLException {
//1.注册驱动
// DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//2.获取连接
Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/mydb1_jdbc”,“root”,“123456”);
//3.执行SQL
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(“select*from student”);
//4.处理结果集
while(resultSet.next()){ //获取每一行数据 每循环一次就是一行
//获取每一列数据
// int sid = resultSet.getInt(“sid”);
int sid = resultSet.getInt(1);
// String sname = resultSet.getString(“sname”);
String sname = resultSet.getString(2);
// int age = resultSet.getInt(“age”);
int age = resultSet.getInt(3);
System.out.println(sid+" "+sname+" "+age);
}
//5.关闭连接
resultSet.close();
statement.close();
connection.close();
}
}
------------------------------------增删改查--------------------------------------------------
package cn.itcast.jdbc;
import java.sql.*;
public class JdbcDemo03 {
public static void main(String[] args) throws SQLException {
//1.注册驱动
//2.获取连接
Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/mydb1_jdbc”, “root”, “123456”);
//3.执行SQL
Statement statement = connection.createStatement();
//3.1增加数据
// int rows1 = statement.executeUpdate(“insert into student values(NULL,‘鲁智深’,40)”);
// //3.2 修改数据
// int rows2 = statement.executeUpdate(“update student set age=48 where sname=‘武松’”);
//3.3 删除数据
int rows3 = statement.executeUpdate(“delete from student where sname=‘鲁智深’”);
System.out.println(rows3);
//5.关闭连接
statement.close();
connection.close();
}
}