返回信息流import javax.swing.*;
import java.sql.*;
import java.util.*;
class Res_Login extends JFrame{
public static String rna=new String("");
public static int rn = new Integer(0);
public Res_Login(){
setTitle("欢迎订餐!");
setSize(DEFAULT_WIDTH, DEFAULT_HEIGHT);
JPanel LoginPan=new JPanel();
LoginPan.setLayout(new GridLayout(2, 2));
final JTextField username=new JTextField();
final JPasswordField password=new JPasswordField();
LoginPan.add(new JLabel("用户名:",SwingConstants.CENTER));
LoginPan.add(username);
LoginPan.add(new JLabel("密码:",SwingConstants.CENTER));
LoginPan.add(password);
add(LoginPan,BorderLayout.CENTER);
JPanel SounthPanel=new JPanel();
add(SounthPanel,BorderLayout.SOUTH);
JButton Yes=new JButton("确认");
SounthPanel.add(Yes);
JButton Cancel=new JButton("取消");
SounthPanel.add(Cancel);
Yes.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent event){
String url1="jdbc:sqlserver://localhost:1433;DatabaseName=Food_Order";
String DriverName1="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String username1="sa";
String pass="19931022";
String loginnamex = username.getText();
String loginnamey=loginnamex.toString();
rna="'"+loginnamey+"'";
String loginPsw = password.getText();
int loginPsw1=new Integer(loginPsw);
Statement sql1;
ResultSet rs1;
ResultSet rs2;
Connection con1;
String command1="SELECT Res_info.Res_pass, Res_info.Res.num FROM Res_info WHERE Res_info.Res_name="+rna;
try{
Class.forName(DriverName1);
}
catch(ClassNotFoundException e)
{
System.out.println(""+e);
}
try{
con1=DriverManager.getConnection(url1,username1,pass);
sql1=con1.createStatement();
rs1=sql1.executeQuery(command1);
int userpsw=0;
while(rs1.next()){
userpsw=rs1.getInt(3);
rn=rs1.getInt(1);
}
if(userpsw==loginPsw1){
ResManage ResM=new ResManage();
ResM.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
ResM.setVisible(true);
}
else System.out.println("请重新登录");
rs1.close();
sql1.close();
}
catch(SQLException e)
{System.out.println(e);}
}
});
Cancel.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent event){
dispose();
}
});
}
public static final int DEFAULT_WIDTH = 300;
public static final int DEFAULT_HEIGHT = 300;
}
这是一条镜像帖。来源:北邮人论坛 / java / #23519同步于 2012/9/21
该镜像源已超过 30 天没有更新,可能在源站已被删除。
Java机器人发帖
java静态变量 找不到符号
lang15987
2012/9/21镜像同步4 回复
订阅后,新回复会通过你的通知中心匿名送达。
4 条回复