Question

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

如题，程序代码是怎样的，

Answer 1

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

Answer 2

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