java做的简单图书管理系统

package Tools;

import java.sql.*;

import org.junit.Test;

public class ConnDB

{

Connection con;

Statement stmt = null;

ResultSet rs = null;

String driverName="com.mysql.jdbc.Driver"; //驱动程序名

String user="root"; //MySQL 配置时的用户名

String password="root"; //MySQL配置时的密码

String url="jdbc:mysql://localhost:3306/library"; //URL指向要访问的数据库地址

///连接数据库

public ConnDB(){

try{

Class.forName(driverName);

//加载数据库程序

con = DriverManager.getConnection(url, user, password); //使用getConnection()方法，连接MySQL数据库！！

if (!con.isClosed()){

System.out.println("连接成功~!");

}

else{

System.out.println("连接失败~!");

}

}catch(Exception e){

System.err.println(e.getMessage());

}

}

//执行SQL查询，并返回查询结果集

public ResultSet select(String sql){

try{

Class.forName(driverName);

con = DriverManager.getConnection(url,user,password);

stmt=con.createStatement();

rs=stmt.executeQuery(sql);

}catch(Exception e){

System.err.println(e.getMessage());

}

return rs;

}

@Test

public void testSelect(){

}

/*执行SQL更新，并返回影响到的记录条数*/

public int update(String sql)

{

int rs=0;

try

{

Class.forName(driverName);

con=DriverManager.getConnection(url,user,password);

stmt=con.createStatement();

rs=stmt.executeUpdate(sql);

}catch(Exception e)

{

System.err.println(e.getMessage());

}

return rs;

}

public void testupdate(){

}

public static void main(String[] args){

new ConnDB();

}

}

package Library.Management.System;

import java.awt.*;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.*;

import javax.swing.text.JTextComponent;

import Tools.ConnDB;

public class addInterface implements ActionListener {

JFrame frame;

JPanel p1,p2,p3;

JLabel l1,l2,l3,l4;

JTextField t1,t2,t3,t4;

JButton last,next,enter,cancel,delete; public addInterface(){

frame = new JFrame("增加/修改");

l1 = new JLabel("图书编号");

t1 = new JTextField(10);

l2 = new JLabel("书本名称");

t2 = new JTextField(10);

l3 = new JLabel("定价");

t3 = new JTextField(10);

l4 = new JLabel("出版社");

t4 = new JTextField(10);

p1 = new JPanel();

p1.add(l1);

p1.add(t1);

p1.add(l2);

p1.add(t2);

p2 = new JPanel();

p2.add(l3);

p2.add(t3);

p2.add(l4);

p2.add(t4);

p3=new JPanel();

last = new JButton("上一条");

next = new JButton("下一条");

enter = new JButton("确认");

delete = new JButton("删除");

cancel = new JButton("取消");

p3.add(last);

p3.add(next);

p3.add(enter);

p3.add(cancel);

p3.add(delete);

enter.addActionListener(this);

cancel.addActionListener(this);

frame.add(BorderLayout.NORTH,p1);