我用java连接access数据库,执行插入的时候插入不进去,查询的时候是没问题的代码:publicclassDBConn{privateConnectionconn=null;privateStatementpreparedStatement=null;privateP...
我用java连接access数据库,执行插入的时候插入不进去,查询的时候是没问题的
代码:
public class DBConn {
private Connection conn = null;
private Statement preparedStatement=null;
private PreparedStatement ps=null;
private ResultSet rs;
public Connection getConn() throws Exception,SQLException{
try{
this.creatConnectInstance();
}catch (Exception e){
System.out.println("数据库连接出现异常!");
e.printStackTrace();
}
return conn;
}
public void creatConnectInstance(){
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D://grbgyp.mdb";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(strurl);
preparedStatement = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
}catch(Exception e){
System.out.println(e.getMessage());
}
}
public void closeConnectInstance(){
try{
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}catch(Exception e){
System.out.println(e.getMessage());
}
}
/*查询方法*/
public ResultSet querySelect(String sql){
try{
ps=getConn().prepareStatement(sql);
rs = ps.executeQuery();
}catch (Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
return rs;
}
/**更新删除方法**/
public int updateSql(String sql){
int flag =-1;
try{
System.out.println(sql);
getConn().setAutoCommit(false);
//ps=getConn().prepareStatement(sql);
//String sql1="insert into users(user_id,username,psw,realname) values(3,sss,ddd,fff)";
ps=getConn().prepareStatement(sql);
flag=ps.executeUpdate();
getConn().commit();
}catch (Exception e){
flag =-1;
e.printStackTrace();
}
return flag;
}
public static void main(String args[]){
try {
int f = new DBConn().updateSql("insert into users (username,psw,realname) values('sss','ddd','fff')");
if(f==1){
System.out.println("插入成功:");
}
}else{
System.out.println("插入失败");
}
}catch (Exception e){
e.printStackTrace();
 
展开