dbconui.java

这是一个班级 教师 学生 课程管理的软件实现对学生教师课程的添加修改删除查询

package view;

import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.SwingConstants;

import logic.logic;

//数据库连接窗口
public class dbconUI extends JFrame implements ActionListener{

	JTextField tfhostname = new JTextField();//主机名
	JTextField tfport = new JTextField();//端口号
	JTextField tfdbuname = new JTextField();// 数据库用户名
	JTextField tfdbupwd = new JPasswordField();//数据库密码
	JCheckBox saveconn = new JCheckBox();//保存复选框
	//--------------------------按钮
	JButton btconnect = new JButton();//连接
	JButton btdefault = new JButton();//默认
	JButton btunconect = new JButton();//断开
	JButton btexitdb = new JButton();//退出
	logic ld=new logic();//实例化业务
	
	//初始化监听
	public void init(){
		btconnect.addActionListener(this);
		btdefault.addActionListener(this);
		btunconect.addActionListener(this);
		btexitdb.addActionListener(this);
	}
	
	
	public dbconUI() {
		init();//调用初始化监听器
		this.setSize(333,251); //窗口大小
		int cx=(int) ((Toolkit.getDefaultToolkit().getScreenSize().width-this.getWidth()))/2;
		int cy=(int) ((Toolkit.getDefaultToolkit().getScreenSize().height-this.getHeight()))/2;
		setLocation(cx,cy);//窗口起始坐标
		setResizable(false);//不能改变窗口大小
		getContentPane().setLayout(null);

		final JLabel label = new JLabel();
		label.setHorizontalAlignment(SwingConstants.RIGHT);
		label.setText("主机名称或 IP:");
		label.setBounds(10, 24, 100, 18);
		getContentPane().add(label);

		final JLabel label_1 = new JLabel();
		label_1.setHorizontalTextPosition(SwingConstants.RIGHT);
		label_1.setHorizontalAlignment(SwingConstants.RIGHT);
		label_1.setText("数据库用户名:");
		label_1.setBounds(10, 76, 100, 18);
		getContentPane().add(label_1);

		final JLabel label_2 = new JLabel();
		label_2.setHorizontalAlignment(SwingConstants.RIGHT);
		label_2.setText("数 据 库 密 码:");
		label_2.setBounds(10, 100, 100, 18);
		getContentPane().add(label_2);

		final JLabel label_3 = new JLabel();
		label_3.setHorizontalAlignment(SwingConstants.RIGHT);
		label_3.setText("数据库端口号:");
		label_3.setBounds(10, 48, 100, 18);
		getContentPane().add(label_3);

		
		tfhostname.setText("localhost");
		tfhostname.setBounds(116, 22, 149, 22);
		getContentPane().add(tfhostname);

		
		tfport.setText("1433");
		tfport.setBounds(116, 48, 149, 22);
		getContentPane().add(tfport);

		
		tfdbuname.setText("sa");
		tfdbuname.setBounds(116, 74, 149, 22);
		getContentPane().add(tfdbuname);

				
		tfdbupwd.setText("sa");
		tfdbupwd.setBounds(116, 98, 149, 22);
		getContentPane().add(tfdbupwd);		
		
		setTitle("不晕校园管理系统->数据库连接");

		
		btconnect.setText("连接");
		btconnect.setBounds(29, 159, 60, 28);
		getContentPane().add(btconnect);

		
		btdefault.setText("默认");
		btdefault.setBounds(95, 159, 60, 28);
		getContentPane().add(btdefault);

		
		btunconect.setText("断开");
		btunconect.setBounds(161, 159, 60, 28);
		getContentPane().add(btunconect);

		
		btexitdb.setText("退出");
		btexitdb.setBounds(231, 159, 60, 28);
		getContentPane().add(btexitdb);

		
		saveconn.setSelected(true);
		saveconn.setText("保存此信息下次不再输入");
		saveconn.setBounds(116, 124, 175, 23);
		getContentPane().add(saveconn);
		
		this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); //关闭方式
		this.setVisible(true);//显示窗口
		
	}//end struct
	
	
	//start main
	public static void main(String[] args) {
		new dbconUI();

	}//end main
	
	
	//------------event
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==btexitdb){
			dispose();
		}//关闭按钮
		
		if(e.getSource()==btdefault){			
			tfhostname.setText("localhost");
			tfport.setText("1433");
			tfdbuname.setText("sa");
			tfdbupwd.setText("sa");
		}
		
		if(e.getSource()==btunconect){
			ld.closeDB();
		}
		if(e.getSource()==btconnect){			
			if(ld.connectDB(tfhostname.getText(), tfport.getText(), tfdbuname.getText(), tfdbupwd.getText())==true){
				new loginUI();
				dispose();
			}
		}
		
	}//end actionlistener

}