package jbdc;
import java.sql.*;
import tools.DBUtil;
public class _3_insert {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = DBUtil.getConn();
PreparedStatement psmt = null;
/// 插入 //
try {
String sql = "insert into user values(?,?,?,?)";
psmt = conn.prepareStatement(sql);
psmt.setString(1, "20002");
psmt.setString(2, "111");
psmt.setString(3, "陈健");
psmt.setString(4, "管理员");
int i = psmt.executeUpdate();//如果插入成功那么返回的值大于0,不成功就返回0
if(i!=0)
System.out.println("插入成功");
else
System.out.println("插入失败");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
DBUtil.close(psmt, conn);
}
}
}