怎样利用java语句向Access数据库中插入一条记录

如题,程序代码是怎样的,
2025-02-26 11:30:37
推荐回答(3个)
回答1:

前面链接数据库操作
插入代码
String s1="";
String s2="";
String s3="'";
String temp="INSERT INTO 表名 VALUES ("+s1+","+s2+","+s3+")";
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql.executeQuery(temp);

回答2:

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();
}
}

回答3:

首先是打开数据库会话
执行SQL