我用JBuilder9开发了一个信用卡查询系统,数据库用的是sql server 2000 sp3,系统的功能很简单,就是输入卡号和密码查询信用卡余额,可以取款和存钱
我碰到的问题是:当我输入卡号和密码时可以连接上数据库,但是取款和存钱时就会出现数据库联接错误,请问各位高手该怎么改
void jButton1_actionPerformed(ActionEvent e) {
try{
today = new java.text.SimpleDateFormat("yyyy-MM-dd", java.util.Locale.US);//
getInsert =con.createStatement();
getUpdate =con.createStatement();
insertString = "insert event (CardID,EventMoney,EventDate) values ("+CardID+","+Integer.parseInt("-"+jTextField1.getText())+",'"+today.format(new java.util.Date())+"')";
updateString = "update card set LeaveMoney = LeaveMoney - "+Integer.parseInt(jTextField1.getText())+" where CardID = "+CardID; getInsert.executeUpdate(insertString);
getUpdate.executeUpdate(updateString); eventFrame.toquery();
}
catch(SQLException ex){
System.out.print("系统get错误,请检测数据库");
}
}
注:我的数据库event(enentID,CardID,EventMoney,EventData)
我碰到的问题是:当我输入卡号和密码时可以连接上数据库,但是取款和存钱时就会出现数据库联接错误,请问各位高手该怎么改
void jButton1_actionPerformed(ActionEvent e) {
try{
today = new java.text.SimpleDateFormat("yyyy-MM-dd", java.util.Locale.US);//
getInsert =con.createStatement();
getUpdate =con.createStatement();
insertString = "insert event (CardID,EventMoney,EventDate) values ("+CardID+","+Integer.parseInt("-"+jTextField1.getText())+",'"+today.format(new java.util.Date())+"')";
updateString = "update card set LeaveMoney = LeaveMoney - "+Integer.parseInt(jTextField1.getText())+" where CardID = "+CardID; getInsert.executeUpdate(insertString);
getUpdate.executeUpdate(updateString); eventFrame.toquery();
}
catch(SQLException ex){
System.out.print("系统get错误,请检测数据库");
}
}
注:我的数据库event(enentID,CardID,EventMoney,EventData)
系统store错误,请检测数据库