高级语言案例分析_QQ_注册

package javaQQ;import java.awt.FlowLayout;import java.awt.GridLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;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_QQ extends JFrame{boolean laFlag=true;User_QQ uQq=new User_QQ();private JLabel loadNamela=null;private JTextField loadNamejt=null;private JLabel namela=null;private JTextField namejt=null;private JLabel passwordla=null;private JPasswordField passwordjp=null;private JLabel passwordla1=null;private JPasswordField passwordjp1=null;private JLabel ipla=null;private JTextField ipjt=null;private JLabel portla=null;private JTextField portjt=null;private JButton loginbtn=null;private JPanel inputJp=null;/*Load_QQ lq=new Load_QQ();*/public Login_QQ(){super("新用户注册");init();}public void init(){//jtak.setEditable(true);inputJp=new JPanel();loadNamela=new JLabel("登录名：");loadNamejt=new JTextField(10);namela=new JLabel("姓名：");namejt=new JTextField(10);passwordla=new JLabel("登录密码：");passwordjp=new JPasswordField(10);passwordla1=new JLabel("确认密码：");passwordjp1=new JPasswordField(10);ipla=new JLabel("ip：");ipjt=new JTextField("127.0.0.1");portla=new JLabel("端口号：");portjt=new JTextField();loginbtn=new JButton("注册");this.setLayout(new FlowLayout());inputJp.setLayout(new GridLayout(7,2));inputJp.add(loadNamela);inputJp.add(loadNamejt);inputJp.add(namela);inputJp.add(namejt);inputJp.add(passwordla);inputJp.add(passwordjp);inputJp.add(passwordla1);inputJp.add(passwordjp1);inputJp.add(ipla);inputJp.add(ipjt);inputJp.add(portla);inputJp.add(portjt);inputJp.add(loginbtn);this.add(inputJp);loginbtn.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e) {insert();}});this.setDefaultCloseOperation(EXIT_ON_CLOSE);this.setSize(600,400);this.setVisible(true);}public void insert(){//插入操作String user="sa";String password="sa";String url="jdbc:sqlserver://localhost:1433;DataBaseName=QQ;";for(int i=0;i<uQq.usernameU.length;i++){if(loadNamejt.getText().trim().equals(uQq.usernameU[i])){laFlag=false;JOptionPane.showMessageDialog(null, "该用户已经被注册,请重新填写");break;}}if(laFlag){if(passwordjp.getText().equals(passwordjp1.getText())){try {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Connection cn=DriverManager.getConnection(url,user,password);String sqlInsert="insert into qqUser(loadname,name,password,ip) values(?,?,?,?)";/*这里如果问号是中文的会报错为索引1超出范围*/PreparedStatement pst=cn.prepareStatement(sqlInsert,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);pst.setString(1, loadNamejt.getText());pst.setString(2, namejt.getText());pst.setString(3, passwordjp.getText());pst.setString(4, ipjt.getText());pst.executeUpdate();this.dispose();JOptionPane.showMessageDialog(null, "注册成功，请前往登陆界面登陆");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}else{JOptionPane.showMessageDialog(null, "密码输入不一致，请重新输入");}}}/*public static void main(String args[]){Login_QQ login_QQ=new Login_QQ();}*/}