帮忙改一下,acess中的数据好象与swing编的程序连不上, if(s==rs.getString("account")){}里的语句都没执行啊?
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
public class myCard extends JFrame implements ActionListener
{
Container myContainer=getContentPane(); //登陆界面
CardLayout myLayout=new CardLayout(); JPanel panel2=new JPanel();
JLabel label2=new JLabel("请输入用户帐号:");
JTextField textfield2=new JTextField(6);
JButton button2=new JButton("注册用户"); JPanel panel3=new JPanel();
JLabel label3=new JLabel("success");
myCard()
{
setSize(500,500);
setTitle("我的卡片");
myContainer.setLayout(myLayout);
myContainer.add(panel2,"panel2");
myContainer.add(panel3,"panel3");
panel2.add(label2);
panel2.add(textfield2);
panel2.add(button2);
button2.addActionListener(this);
panel3.add(label3); myLayout.show(myContainer,"panel2");
}
public void actionPerformed(ActionEvent e)
{
String s=new String(textfield2.getText());
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=g:/J/db1.mdb";
Connection connection=DriverManager.getConnection(url,"","");
Statement statement=connection.createStatement();
String sql="Select * from table2 where ID=1";
ResultSet rs=statement.executeQuery(sql);
if(rs!=null)
{
while(rs.next())
{
System.out.println(rs.getString("account"));
}
}
if(e.getSource()==button2)
{
if(s==rs.getString("account"))
{
myLayout.show(myContainer,"panel3");
}
else
{
System.exit(0);
}
}
rs.close();
connection.close();
statement.close();
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
public static void main(String args[])
{
myCard frame=new myCard();
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.show();
}
}
ID account password name sex age date
1 20050001 111111 peng male 22 2005-6-1
2 20050002 222222 zhang male 21 2005-6-1
3 20050003 333333 jia female 20 2005-6-1
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
public class myCard extends JFrame implements ActionListener
{
Container myContainer=getContentPane(); //登陆界面
CardLayout myLayout=new CardLayout(); JPanel panel2=new JPanel();
JLabel label2=new JLabel("请输入用户帐号:");
JTextField textfield2=new JTextField(6);
JButton button2=new JButton("注册用户"); JPanel panel3=new JPanel();
JLabel label3=new JLabel("success");
myCard()
{
setSize(500,500);
setTitle("我的卡片");
myContainer.setLayout(myLayout);
myContainer.add(panel2,"panel2");
myContainer.add(panel3,"panel3");
panel2.add(label2);
panel2.add(textfield2);
panel2.add(button2);
button2.addActionListener(this);
panel3.add(label3); myLayout.show(myContainer,"panel2");
}
public void actionPerformed(ActionEvent e)
{
String s=new String(textfield2.getText());
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=g:/J/db1.mdb";
Connection connection=DriverManager.getConnection(url,"","");
Statement statement=connection.createStatement();
String sql="Select * from table2 where ID=1";
ResultSet rs=statement.executeQuery(sql);
if(rs!=null)
{
while(rs.next())
{
System.out.println(rs.getString("account"));
}
}
if(e.getSource()==button2)
{
if(s==rs.getString("account"))
{
myLayout.show(myContainer,"panel3");
}
else
{
System.exit(0);
}
}
rs.close();
connection.close();
statement.close();
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
public static void main(String args[])
{
myCard frame=new myCard();
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.show();
}
}
ID account password name sex age date
1 20050001 111111 peng male 22 2005-6-1
2 20050002 222222 zhang male 21 2005-6-1
3 20050003 333333 jia female 20 2005-6-1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货