前面链接数据库操作
插入代码
String s1="";
String s2="";
String s3="'";
String temp="INSERT INTO 表名 VALUES ("+s1+","+s2+","+s3+")";
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql.executeQuery(temp);
public static void insert(int id, String name, String age){
String sql = "insert into 表名(id, name, age) value (?,?,?);";
try {
Class.forName("驱动");
Connection conn = DriverManager.getConnection("地址","数据库名","数据库密码");
PreparedStatement psm = conn.prepareStatement(sql);
psm.setInt(1,id);
psm.setString(2, name);
psm.setString(3, age);
int i = psm.executeUpdate();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
首先是打开数据库会话
执行SQL