java数据库连接问题求助,有源码,请高手帮改改。
我用JAVA做了功能简单的图书管理系统,能够实现增,删,改,就是不能查询,不能实现登陆界面。
源码如下,请高手帮改改!我用的是DB2.
package zxl;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class Enter implements ActionListener
{
JTextField user;
JPasswordField passWd;
Container contentPane;
JButton b1,b2;
JPanel pan1,pan2,pan3,pan4;
JFrame bms;
JDialog dialog;
JLabel label;
Connection conn;
Statement stmt;
ResultSet rs;
String str1,str2,name,passwd,sql;
public Enter(JFrame bms)
{
dialog=new JDialog(bms,"登陆",true);
contentPane=dialog.getContentPane();
pan1=new JPanel();
pan2=new JPanel();
pan3=new JPanel();
pan4=new JPanel();
pan1.add(new JLabel("用户",SwingConstants.CENTER));
user=new JTextField("",10);
pan1.add(user);
pan2.add(new JLabel("密码",SwingConstants.CENTER));
passWd=new JPasswordField("",10);
pan2.add(passWd);
b1=new JButton ("确定");
b2=new JButton ("取消");
pan3.add(b1);
pan3.add(b2);
label=new JLabel();
pan4.add(label);
b1.addActionListener(this);
b2.addActionListener(this);
contentPane.setLayout(new GridLayout(4,1));
contentPane.add(pan1);
contentPane.add(pan2);
contentPane.add(pan3);
contentPane.add(pan4);
dialog.setBounds(200,150,250,150);
dialog.show();
}
public void actionPerformed(ActionEvent e)
{
name=user.getText();
passwd=passWd.getText();
label.setText("用户名:"+name+" 密码:"+passwd);
//System.out.println(name+passwd);
if(e.getActionCommand().equals("确定"))
{
sql="select * from USER where NAME='";
sql+=name+"' and PASSWORD='";
sql+=passwd+"'";
System.out.println(sql);
conn=ConnectDB2.getConnection();
rs=ConnectDB2.getResultSet(sql);
try
{
while(rs.next())
{
str1=rs.getString("1");
str2=rs.getString("2");
}
}
catch(Exception ec)
{
}
ConnectDB2.disConnection(conn);
}
if(e.getActionCommand().equals("取消"))
{
System.exit(0);
}
}
}
package zxl;
import java.sql.*;
public class ConnectDB2
{
public static Connection conn;
public static Statement stmt;
public static ResultSet rs;
public static Connection getConnection()
{
try
{
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
conn=DriverManager.getConnection("jdbc:db2:ZXL","","");
}
catch(Exception e)
{
}
return conn;
}
public static boolean disConnection(Connection conn)
{
boolean successed=false;
try{
if(conn!=null)
conn.close();
successed=true;
}
catch(Exception e)
{
}
return successed;
}
public static ResultSet getResultSet(String sql)
{
try {
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch (Exception e)
{
}
return rs;
}
public static boolean executeSQL(String sql)
{
boolean returnVal=true;
try
{
stmt=conn.createStatement();
returnVal=stmt.execute(sql);
disConnection(conn);
}catch(Exception e)
{
}
return returnVal;
}
}
package zxl;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class BMS implements ActionListener
{
public JFrame bms=null;
public BMS()
{ JMenu sys,bm,lm,hp,user;
JMenuItem enter,exit,adduser,alteruser,deleteuser,addbk,modifybk,deletebk,borrowbk,borrowmodif,returnbk,returnmodif,about;
JMenuBar mb;
bms=new JFrame("图书管理系统");
Font myFont=new Font("楷体_GB2312",Font.BOLD,60);
JLabel ml=new JLabel("图书管理系统",SwingConstants.CENTER);
ml.setFont(myFont);
bms.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
bms.dispose();
System.exit(0);
}
});
bms.add(ml);
mb=new JMenuBar();
sys=new JMenu("系统");
bm=new JMenu("图书管理");
lm=new JMenu("借阅管理");
hp=new JMenu("帮助");
mb.add(sys);
mb.add(bm);
mb.add(lm);
mb.add(hp);
enter=new JMenuItem("登陆");
user=new JMenu("用户管理");
adduser=new JMenuItem("添加用户");
alteruser=new JMenuItem("修改用户");
deleteuser=new JMenuItem("删除用户");
exit=new JMenuItem("退出");
enter.addActionListener(this);
exit.addActionListener(this);
adduser.addActionListener(this);
alteruser.addActionListener(this);
deleteuser.addActionListener(this);
user.add(adduser);
user.add(alteruser);
user.add(deleteuser);
sys.add(enter);
sys.add(user);
sys.addSeparator();
sys.add(exit);
addbk=new JMenuItem("添加书籍");
modifybk=new JMenuItem("修改书籍");
deletebk=new JMenuItem("删除书籍");
bm.add(addbk);
bm.add(modifybk);
bm.add(deletebk);
addbk.addActionListener(this);
modifybk.addActionListener(this);
deletebk.addActionListener(this);
borrowbk=new JMenuItem("当前出借信息");
borrowmodif=new JMenuItem("出借信息修改");
returnbk=new JMenuItem("当前出借信息");
returnmodif=new JMenuItem("出借信息修改");
lm.add(borrowbk);
lm.add(borrowmodif);
lm.addSeparator();
lm.add(returnbk);
lm.add(returnmodif);
about=new JMenuItem("关于");
hp.add(about);
bms.setJMenuBar(mb);
bms.setBounds(150,60,800,600);
bms.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
if(e.getActionCommand().equals("登陆"))
{
new Enter(bms);
}
if(e.getActionCommand().equals("退出"))
{
bms.dispose();
System.exit(0);
}
if(e.getActionCommand().equals("添加用户"))
{
new Adduser(bms);
}
if(e.getActionCommand().equals("修改用户"))
{
new Alteruser(bms);
}
if(e.getActionCommand().equals("删除用户"))
{
new Deleteuser(bms);
}
if(e.getActionCommand().equals("添加书籍"))
{
new Addbk(bms);
}
if(e.getActionCommand().equals("修改书籍"))
{
new Modifybk(bms);
}
if(e.getActionCommand().equals("删除书籍"))
{
}
}
public static void main(String[] args)
{
new BMS();
}
}