CURD:增删改查
Class.forName(JDBC驱动类)
//1.导入jar包,部署
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class AddTest {
//1.导入jar包,部署
//2.加载驱动(包)只加载一次
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/bdqn229";
String user = "root";//账户名
String pwd = "root";//密码
Statement st =null;
Connection conn = null;
try {
//3.创建连接对象
conn = (Connection) DriverManager.getConnection(url, user, pwd);
//4.Sql语句
String sql = "insert into bank ";
//5.执行对象
st = conn.createStatement();
//6.执行
int result = st.executeUpdate(sql);
//7.返回结果
if(result>0){
System.out.println("修改成功");
}else{
System.out.println("修改失败");
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(st!=null){
st.close();
}
if(conn!=null){
conn.close();
}
} catch (Exception e2) {
// TODO: handle exception
}
}
}
}
prepareStatement:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class epetadmin {
//1.导入jar包,部署
//2.加载驱动(包)只加载一次
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/epet";
String user = "root";//账户名
String pwd = "root";//密码
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
//3.创建连接对象
try {
conn = DriverManager.getConnection(url, user, pwd);
//4.Sql语句
String sql = "insert into Dog(id,name,zhong) values(?,?,?) ";
//5.执行对象
ps = conn.prepareStatement(sql);
//6.执行
ps.setInt(1,1 );
ps.setString(2, "阿斯顿");
ps.setString(3, "sdaad");
ps.execute();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(conn!=null){
conn.close();
}
if(ps!= null){
ps.close();
}
} catch (Exception e2) {
}
}
}
}