import javax.swing.*;
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JFrameDemo
{String passwordD=null;
public static String persontyDD=null;
public JFrameDemo(){
final JFrame frame1 = new JFrame("超市管理系统登陆界面");
final JButton button = new JButton("登陆");
JLabel labelName = new JLabel("请输入账号");
JLabel labelNumber = new JLabel("请输入密码");
final JTextField tfName = new JTextField(12);
final JTextField tfNumber = new JTextField(12);
JMenuBar menubar = new JMenuBar();
JMenu mu = new JMenu("功能");
JMenuItem help = new JMenuItem("帮助");
JMenuItem quet = new JMenuItem("退出");
button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
Connection con;
Statement sql;
ResultSet rs = null;String fu="超级用户";
if(e.getSource()==button)
{
String idin = tfName.getText();
String keyin = tfNumber.getText();
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433;databaseName=Supermarket";
String user="sa";
String password="123456";
con=DriverManager.getConnection(url,user,password);
sql = con.createStatement();
rs = sql.executeQuery("SELECT * FROM password where ID='"
+ idin + "'");
while (rs.next()) {
passwordD= rs.getString(2); persontyDD= rs.getString(3);
}
con.close();
} catch (Exception g)
{System.out.println(g);}
if (persontyDD!=null)
{
frame1.dispose();
ViewDemo frame=new ViewDemo();
System.out.println(persontyDD);
if(persontyDD==fu){
System.out.println("1");
}}}
else
{
frame1.dispose();
Close frame=new Close();
}
}} );
public static void main(String args[]) {
new JFrameDemo();
}}
料青山看我应如是
拉风的咖菲猫
互换的青春
相关分类