register.java

一个基于java的局域网聊天程序

import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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;
import javax.swing.border.EtchedBorder;
import javax.swing.border.TitledBorder;


public class Register extends JFrame {

	private JPasswordField passwordField;
	private JTextField textField;
	final JButton button = new JButton();
	

	public Register() {
		super("注册信息");
		pack();
		getContentPane().setLayout(null);
		setSize(400, 400);
		setResizable(false);
		
		setVisible(true);

		final JPanel panel = new JPanel();
		panel.setBackground(Color.CYAN);
		panel.setLayout(null);
		panel.setBorder(new TitledBorder(null, "注册内容（*为必填项目）", TitledBorder.DEFAULT_JUSTIFICATION, TitledBorder.DEFAULT_POSITION, null, null));
		panel.setBounds(48, 34, 298, 272);
		getContentPane().add(panel);

		final JLabel label = new JLabel();
		label.setText("帐 号（*）：");
		label.setBounds(35, 40, 73, 18);
		panel.add(label);

		textField = new JTextField();
		textField.setBounds(118, 38, 87, 22);
		panel.add(textField);

		final JLabel label_1 = new JLabel();
		label_1.setText("密 码（*）：");
		label_1.setBounds(35, 77, 73, 18);
		panel.add(label_1);

		passwordField = new JPasswordField();
		passwordField.setBounds(118, 75, 87, 22);
		panel.add(passwordField);

		button.addActionListener(new SureRegister());

		button.setText("确 定");
		button.setBounds(256, 312, 79, 28);
		getContentPane().add(button);
	}
	class SureRegister implements ActionListener {
		public void actionPerformed(ActionEvent e) {
			String account=textField.getText();
			String pwd=new String(passwordField.getPassword());
			try {
				Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			} catch (ClassNotFoundException e2) {
				e2.printStackTrace();
			} 
			String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xiajing";  
			String user="sa"; 
			String password=""; 
			Connection con;
			try {
				con = DriverManager.getConnection(url,user,password);
				Statement state=con.createStatement();
				String sqlStr="select * from register where 帐号 = '"+account+"'";
				ResultSet rs1=state.executeQuery(sqlStr);
				if(rs1.next())
					JOptionPane.showMessageDialog(null, "该用户名已经存在，请重新注册...", "错误",JOptionPane.ERROR_MESSAGE);
				else {
				String sql="insert into register values('"+account+"','"+pwd+"')";
				System.out.println(sql);
				state.execute(sql);
				ResultSet rs=state.executeQuery("select * from register");
				while(rs.next())
					System.out.println(rs.getString(1));
				JOptionPane.showMessageDialog(null, "恭喜，注册成功！！！", "友情提示", JOptionPane.INFORMATION_MESSAGE);
				dispose();
				}
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			
		}
		
	}
	public static void main(String[] args) {
		new Register();
	}

}