验证登录的按钮单击事件:
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(e.getSource()==loginBtn){
username = userTxtFld.getText();
psw = new String(pswTxtFld.getPassword());
username.trim();
psw.trim();
//建立数据库连接
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Properties props = new Properties();
props.put("user","sa");
props.put("password","sa");
props.put("DataBaseName","directory");
conn = DriverManager.getConnection ("jdbc.microsoft:sqlserver://127.0.0.1:1433",props);
String SQLstr="select * from userinfo where username='"+username+"'and passward= '"
+psw+"'";
rs= stmt.executeQuery(SQLstr);
int count = 1;
while(rs.next()){
count++;
}
if(count>0){//身份正确
JOptionPane correctMsg= new JOptionPane();
JLabel msgLbl1 = new JLabel("成功登录!");
correctMsg.showMessageDialog(null,msgLbl1,"恭喜您:",JOptionPane.ERROR_MESSAGE);
}
else{
JOptionPane errorMsg= new JOptionPane();
JLabel msgLbl2 = new JLabel("用户名或密码错误!请重新输入!");
errorMsg.showMessageDialog(null,msgLbl2,"系统提示:",JOptionPane.ERROR_MESSAGE);
userTxtFld.setText("");
pswTxtFld.setText("");
userTxtFld.requestFocus();
}
}catch(Exception ex){
//System.out.println("登录失败!,请重试。"+ex);
}finally{
try{
if(rs!=null){
rs.close();
}
if(stmt!=null){
stmt.close();
}
if(conn!=null){
conn.close();
}
}catch(SQLException sqle){}
}
}//end if
else if(e.getSource()==exitBtn){
System.exit(0);
} JDBC 驱动我也装了,我的classpath路径为: %JAVA_HOME%\bin\tools.jar;%JAVA_HOME% \bin\dt.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib
数据源也设过了。。怎么按“登录“按钮时,一点反应也没有啊?哪位高手帮我看看啊?小弟先谢了
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(e.getSource()==loginBtn){
username = userTxtFld.getText();
psw = new String(pswTxtFld.getPassword());
username.trim();
psw.trim();
//建立数据库连接
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Properties props = new Properties();
props.put("user","sa");
props.put("password","sa");
props.put("DataBaseName","directory");
conn = DriverManager.getConnection ("jdbc.microsoft:sqlserver://127.0.0.1:1433",props);
String SQLstr="select * from userinfo where username='"+username+"'and passward= '"
+psw+"'";
rs= stmt.executeQuery(SQLstr);
int count = 1;
while(rs.next()){
count++;
}
if(count>0){//身份正确
JOptionPane correctMsg= new JOptionPane();
JLabel msgLbl1 = new JLabel("成功登录!");
correctMsg.showMessageDialog(null,msgLbl1,"恭喜您:",JOptionPane.ERROR_MESSAGE);
}
else{
JOptionPane errorMsg= new JOptionPane();
JLabel msgLbl2 = new JLabel("用户名或密码错误!请重新输入!");
errorMsg.showMessageDialog(null,msgLbl2,"系统提示:",JOptionPane.ERROR_MESSAGE);
userTxtFld.setText("");
pswTxtFld.setText("");
userTxtFld.requestFocus();
}
}catch(Exception ex){
//System.out.println("登录失败!,请重试。"+ex);
}finally{
try{
if(rs!=null){
rs.close();
}
if(stmt!=null){
stmt.close();
}
if(conn!=null){
conn.close();
}
}catch(SQLException sqle){}
}
}//end if
else if(e.getSource()==exitBtn){
System.exit(0);
} JDBC 驱动我也装了,我的classpath路径为: %JAVA_HOME%\bin\tools.jar;%JAVA_HOME% \bin\dt.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib
数据源也设过了。。怎么按“登录“按钮时,一点反应也没有啊?哪位高手帮我看看啊?小弟先谢了
解决方案 »
- button事件中实时更新组件问题
- 在eclipse怎么对main的String[] args传参,然后将它输出
- java学习方向问题(数据库,网络开发)
- 怎样实现JFormattedTextField只能输入小数?在线等待中.....!谢谢
- 求高手进来,菜鸟数据库连接问题
- 如何由一个URL类得到一个File类?急!!
- Exception in thread "main" java.lang.NoClassDefFoundError :~~ 。怎么解决?
- 请教CachedRowSet的问题
- 如何將一個String 類型的變量轉換成 double類型.
- jre如果不设java_home就形同虚设吗?
- applet与servlet进行通讯的问题
- Java混淆器
另外:我把catch里的异常打印后结果为:登录失败!,请重试。java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
驱动也装了,classpath路径也改为:
%JAVA_HOME%\lib\tools.jar;%JAVA_HOME%\lib\dt.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;
还是上面那个错误
怎么连数据库这么难啊!!
一般都是这里容易出现问题!
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=???";
String user = "sa";
String password = "";conn = DriverManager.getConnection(url, user,password);
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;
还是添加
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib
这一句啊??
也要设置在classpath还有你的java_home没有设置吧
msutil.jar;
mssqlserver.jar
拷到这个目录下就可以了C:\j2sdk1.4.2_05\jre\lib\ext