package conn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Jdbcfile
{
//申明变量
Connection conn;
Statement stmt;
int inorupdatevalue = -1;
//申明构造方法并抛出异常
public Jdbcfile() throws Exception
{
try
{
String drivername = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc.sqlserver://localhost:1433;DatabaseName = library";
Class.forName(drivername);
conn = DriverManager.getConnection(dbURL,"sa","123");////////////////////////(1)
stmt = conn.createStatement();
}catch(ClassNotFoundException e){
//捕获异常
throw new Exception("数据驱动未找到" + e.getException());
}catch(SQLException e){
//捕获异常
throw new Exception("数据库未连接" + e.getMessage());
}
}
//定义查询数据的方法
public synchronized ResultSet executeQuery(String sql)throws Exception{
ResultSet rs = stmt.executeQuery(sql);
return rs;
}
//定义插入数据的方法
public synchronized int insert(String sql)throws Exception{
inorupdatevalue = stmt.executeUpdate(sql);
return inorupdatevalue;
}
//定义删除数据的方法
public synchronized int del(String sql)throws Exception{
inorupdatevalue = stmt.executeUpdate(sql);
return inorupdatevalue;
}
//定义关闭数据库连接的方法
public void close()throws Exception{
conn.close();
}
}
package admin;
import java.awt.Container;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
import conn.Jdbcfile;
public class Login extends JFrame
{
//声明标签、按钮、文本框密码框
private JLabel JLb1;
private JLabel JLb2;
private JButton OK_btn;
private JButton Cancel_btn;
private JTextField jtflduser;
private JPasswordField jtpwdfld;
//声明窗口
private JFrame frame;
//构造方法
public Login()
{
frame = new JFrame("登入");
Container content = frame.getContentPane();
//采用GridLayout布局管理器
content.setLayout(new GridLayout(3,2,20,20));
JLb1 = new JLabel("用户名");
JLb2 = new JLabel("密 码");
//将标签置于居中位置
JLb1.setHorizontalAlignment(SwingConstants.CENTER);
JLb2.setHorizontalAlignment(SwingConstants.CENTER);
jtflduser = new JTextField();
jtpwdfld = new JPasswordField();
OK_btn = new JButton("确定");
Cancel_btn = new JButton("取消");
//为按钮添加事件监听者
OK_btn.addActionListener(new ActionHandler());
Cancel_btn.addActionListener(new ActionHandler());
//添加标签、文本框、密码框和按钮到窗口
content.add(JLb1);
content.add(jtflduser);
content.add(JLb2);
content.add(jtpwdfld);
content.add(OK_btn);
content.add(Cancel_btn);
frame.pack();
//设定登入窗口启动时出现在屏幕中央位置
frame.setLocationRelativeTo(null);
frame.setSize(300,200);
frame.setVisible(true);
}//Login() method
/**
* 实现ActionListener监听，激活组件响应
*/
class ActionHandler implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
String str1,str2,sqlStr;
Object obj = e.getSource();
//获得文本框和密码框的数据