1.了解JDBC的常用类和接口
DriverManager类 用来管理数据库中的所有驱动程序
Connection接口 代表与特定的数据库的连接
Statement接口 用于创建向数据库中传递SQL语句的对象
PreparedStatement 接口 PreparedStatement 接口继承Statement,用于执行动态的SQL语句
ResultSet 接口 用来暂时存放数据库查询操作所获得的结果集
2. MySQL数据库安装、与表(user)创建
3..实例demo
3.1 加载MySQL JDBC驱动 mysql-connector-java-5.1.31-bin.jar
3.2实例代码
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import com.mysql.jdbc.Connection;
public class ToStringTrame {
public Connection getConn() throws SQLException{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO: handle exception
e.printStackTrace();
}
String url="jdbc:mysql://localhost:3306/test?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8";
String userName="root";
String passWord="123456";
Connection conn = DriverManager.getConnection(url, userName, passWord);
// 连接另外操作
java.sql.Connection conn = null;
try {
conn = DriverManager.getConnection(url, userName, passWord);
if (conn!=null){}
} catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}
java.sql.Connection conn = null;
// 数据插入方法1
String sql="insert into user(ID,name,age) value('8','王三','5')";
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
// 数据插入方法2
for (int i=1;i<10;i++){
String sql = "insert into user(ID,name,age) value(?,?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
//
//
ps.setInt(1, 19+i);
ps.setString(2, "李四"+i);
ps.setInt(3, 25+i);
//
//
ps.executeUpdate();
}
// 查询数据方法1
Statement stmt=conn.createStatement();
String sql="select * from user";
ResultSet rs =stmt.executeQuery(sql);
int id,age;
String name;
System.out.println("编号\t 用户名\t 年龄");
while(rs.next()){
id=rs.getInt("ID");
name=rs.getString("name");
age=rs.getInt("age");
System.out.println(id+"\t"+name+"\t"+age);
}
//修改数据1
String sql="update user set name='咋那个三2' where ID=23";
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
//修改数据2
int counts=0;
for (int i=1;i<10;i++){
String sql="update user set name=? where id=?";
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1,"张三"+i);
ps.setInt(2, 20+i);
ps.executeUpdate();
counts++;
}
System.out.println(counts);
// 删数据
String sql="delete from user where id = 23";
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
conn.close();
System.out.println("UPsucess");
return conn;
}
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
ToStringTrame tt=new ToStringTrame();
tt.getConn();
}
}