货存管理系统 java sql

或存管理系统

终于结束了数据库的课设，做了货存管理系统，我做了java部分，完成了很简单的界面的交互功能的实现和与数据库的链接，做的很简单，功能也很不好^ – ^{ { {！！！！

将与数据库的链接进行了封装，每次只需调用传入账号和密码

public class jdbcUtil {
	Connection con = null;
	PreparedStatement ps1 =null;
	ResultSet rs = null;
	InputStream is=null;
	OutputStream os= null;
	public static Connection getMysqlConn(String name,String pwd) {
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		try {
			return DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=货存管理系统",name,pwd);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
		
	}
	
	public static void close(ResultSet rs,Statement ps,Connection con) {
		if(rs!=null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(ps!=null) {
			try {
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(con!=null) {
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	}
	
	
}

	

}

登陆界面

import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;

public class Login extends JFrame implements ActionListener{
	private static final long serialVersionUID = -5978502250361767960L;
	//按钮
	JButton btnLogin,btnRegister,btnCancel;
	//创建中间容器
	JPanel pnlSouth,pnlNorth,pnlCenter,pnlCenter1,pnlCenter2;
	//标签
	JLabel lbl1,JLabelNum,JLabelPwd;
	//用户名文本框
	JTextField tfNum;
	//密码文本框
	JPasswordField tfPwd;
	//创建窗口
	String url = "com.mysql.jdbc.Driver";
	Login(String title){
		super(title);
		
		//north
		pnlNorth = new JPanel();
		lbl1 = new JLabel("欢迎进入货存系统！");
		pnlNorth.add(lbl1);
		this.add(pnlNorth,BorderLayout.NORTH);
		
		//center
		pnlCenter=new JPanel();
		pnlCenter1=new JPanel();
		pnlCenter2=new JPanel();
		pnlCenter.setLayout(new BorderLayout());
		JLabelNum=new JLabel("学   号：");
		tfNum=new JTextField(15);
		pnlCenter1.add(JLabelNum);
		pnlCenter1.add(tfNum);
		pnlCenter.add(pnlCenter1,BorderLayout.NORTH);
		JLabelPwd=new JLabel("密    码：");
		tfPwd=new JPasswordField(15);
		pnlCenter2.add(JLabelPwd);
		pnlCenter2.add(tfPwd);
		pnlCenter.add(pnlCenter2,BorderLayout.SOUTH);
		this.add(pnlCenter,BorderLayout.CENTER); 

		//south
		pnlSouth = new JPanel();
		
		//生成按钮
		btnLogin = new JButton("登录");
		btnLogin.addActionListener(this);

		btnRegister = new JButton("注册");
		btnRegister.addActionListener(this);

		
		btnCancel = new JButton("取消");
		btnCancel.addActionListener(this);

		//将三个按钮放在一个中间容器中
		pnlSouth.add(btnLogin);
		
		pnlSouth.add(btnRegister);
		pnlSouth.add(btnCancel);
		//将按钮添加到图形界面
		//this.add(btnLogin);
		//this.add(btnRegister);
		//this.add(