求一个JAVA应用系统能实现对数据库数据的增删改查就可以!谢谢

来源:百度知道 编辑:UC知道 时间:2024/07/08 18:08:17
用SQL ACCESS均可.

public class DbManager {
private Connection con;
private Statement stm;
public DbManager() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bbs",
"sa", "");

} catch (SQLException ex) {
System.out.println(ex.getMessage());
} catch (ClassNotFoundException ex) {
System.out.println(ex.getMessage());
}

}

public int exeSql(String sql) {

try {
stm = con.createStatement();
return stm.executeUpdate(sql);
} catch (SQLException ex) {
return 0;
}

}

public ResultSet query(String sql) {