Connection connection;
PreparedStatement statement;
PreparedStatement statement1;
Statement stmt;
ResultSet result;
ResultSet rs;
connection=DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=F:\\javachat\\chat.mdb");这里能查询的
String sql="select ID from user";
statement=connection.prepareStatement(sql);
result=statement.executeQuery();
到这里就不能查询了
String sql="SELECT * FROM user WHERE ID='"+str[1]+"' and PWD='"+str[2]+"'";
statement1=connection.prepareStatement(sql);
rs=statement1.executeQuery();说数据库驱动出错!!!!!!!!!!
PreparedStatement statement;
PreparedStatement statement1;
Statement stmt;
ResultSet result;
ResultSet rs;
connection=DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=F:\\javachat\\chat.mdb");这里能查询的
String sql="select ID from user";
statement=connection.prepareStatement(sql);
result=statement.executeQuery();
到这里就不能查询了
String sql="SELECT * FROM user WHERE ID='"+str[1]+"' and PWD='"+str[2]+"'";
statement1=connection.prepareStatement(sql);
rs=statement1.executeQuery();说数据库驱动出错!!!!!!!!!!
所以第二次打开的时候会冲突