java窗口连接_JAVA简单的注册窗口（连接数据库）

创建如图所示的面板

import java.awt.Component;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.util.Vector;

import javax.swing.ButtonGroup;

import javax.swing.ComboBoxModel;

import javax.swing.DefaultComboBoxModel;

import javax.swing.JButton;

import javax.swing.JCheckBox;

import javax.swing.JComboBox;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JRadioButton;

import javax.swing.JTextArea;

import javax.swing.JTextField;

import javax.swing.SwingUtilities;

import javax.swing.WindowConstants;

import javax.swing.border.LineBorder;

public class MyJFrame extends javax.swing.JFrame {

private

JLabel name;

private

JLabel sex;

private

JPanel jPanel1;

private

ButtonGroup sexGroup;

private

JComboBox dayList;

private

JComboBox monthList;

private

JComboBox yearList;

private

JButton reverseSelect;

private

JButton notSelectAll;

private

JButton selectAll;

private

JPanel jPanel2;

private

JCheckBox dance;

private

JCheckBox sing;

private

JCheckBox readbook;

private

JTextArea jTextArea1;

private

JLabel day;

private

JLabel month;

private

JLabel year;

private

JButton reset;

private

JButton regs;

private

JLabel details;

private

JLabel hobby;

private

JLabel birthday;

private

JRadioButton female;

private

JRadioButton male;

private

JTextField jTextField3;

private

JTextField jTextField2;

private

JTextField jTextField1;

private

JLabel confirmPass;

private

JLabel password;

private int

days=0;

public

static void main(String[] args) {

SwingUtilities.invokeLater(new Runnable() {

public void run() {

MyJFrame inst = new MyJFrame();

inst.setLocationRelativeTo(null);

inst.setVisible(true);

}

});

}

public

MyJFrame() {

super();

initGUI();

}

private void

initGUI() {

try {

setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);

getContentPane().setLayout(null);

this.setTitle("\u6ce8\u518c\u7a97\u53e3");

{

name = new JLabel();

getContentPane().add(name);

name.setText("\u5e10\u53f7");

name.setBounds(28, 47, 50, 30);

}

{

password = new JLabel();

getContentPane().add(password);

password.setText("\u5bc6\u7801");

password.setBounds(28, 93, 50, 30);

}

{

confirmPass = new JLabel();

getContentPane().add(confirmPass);

confirmPass.setText("\u786e\u8ba4\u5bc6\u7801");

confirmPass.setBounds(18, 139, 60, 30);

}

{

sex = new JLabel();

getContentPane().add(sex);

sex.setText("\u6027\u522b");

sex.setBounds(18, 242, 50, 30);

}

{

jTextField1 = new JTextField();

getContentPane().add(jTextField1);

jTextField1.setBounds(96, 44, 100, 30);

}

{

jTextField2 = new JTextField();

getContentPane().add(jTextField2);

jTextField2.setBounds(96, 94, 100, 30);

}

{

jTextField3 = new JTextField();

getContentPane().add(jTextField3);

jTextField3.setBounds(96, 140, 100, 30);

}

{

jPanel1 = new JPanel();

getContentPane().add(jPanel1);

jPanel1.setBounds(96, 192, 105, 133);

jPanel1.setEnabled(false);

jPanel1.setLayout(null);

jPanel1.setBorder(new LineBorder(new java.awt.Color(0,0,0), 1,

false));

{

male = new JRadioButton();

jPanel1.add(male);

male.setText("male");

male.setBounds(13, 32, 74, 30);

getSexGroup().add(male);

}

{

female = new JRadioButton();

jPanel1.add(female);

female.setText("female");

female.setBounds(13, 73, 74, 30);

getSexGroup().add(female);

}

}

{

birthday = new JLabel();

getContentPane().add(birthday);

birthday.setText("\u751f\u65e5");

birthday.setBounds(234, 47, 50, 30);

}

{

hobby = new JLabel();

getContentPane().add(hobby);

hobby.setText("\u5174\u8da3");

hobby.setBounds(234, 93, 50, 30);

}

{

details = new JLabel();

getContentPane().add(details);

details.setText("\u5907\u6ce8");

details.setBounds(235, 192, 24, 17);

details.setSize(50, 30);

}

{

regs = new JButton();

getContentPane().add(regs);

regs.setText("\u6ce8\u518c");

regs.addActionListener(new ActionListener(){

@Override

public void actionPerformed(ActionEvent arg0) {

Conn conn=new Conn();

//获取文本域的每个值

String name=jTextField1.getText();

String pwd1=jTextField2.getText();

String pwd2=jTextField3.getText();

String

sex=female.isSelected()?"f":"m";

String

birth=yearList.getSelectedItem()+"-"+monthList.getSelectedItem()+"-"+dayList.getSelectedItem();

String hobby=new String();

if(readbook.isSelected())

hobby+=readbook.getText();

if(dance.isSelected())

hobby+=dance.getText();

if(sing.isSelected())

hobby+=sing.getText();

String detail=details.getText();

if(pwd1.equals(pwd2)){

int row=conn.insert(name, pwd1, sex, birth, hobby,

detail);

if(row!=0)

JOptionPane.showMessageDialog(new JFrame(),

"注册成功");

else

JOptionPane.showMessageDialog(new JFrame(),

"未能成功注册");

}else

JOptionPane.showMessageDialog(new JFrame(),

"两次输入的密码不一样");

}

});

regs.setBounds(196, 375, 65, 24);

}

{

reset = new JButton();

getContentPane().add(reset);

reset.setText("\u91cd\u7f6e");

reset.setBounds(285, 375, 65, 24);

}

{

year = new JLabel();

getContentPane().add(year);

year.setText("\u5e74");

year.setBounds(345, 47, 20, 30);

}

{

month = new JLabel();

getContentPane().add(month);

month.setText("\u6708");

month.setBounds(447, 47, 20, 30);

}

{

day = new JLabel();

getContentPane().add(day);

day.setText("\u65e5");

day.setBounds(547, 47, 20, 30);

}

{

jTextArea1 = new JTextArea();

getContentPane().add(jTextArea1);

jTextArea1.setBounds(296, 215, 308, 141);

}

{

jPanel2 = new JPanel();

getContentPane().add(jPanel2);

jPanel2.setBounds(297, 101, 298, 102);

jPanel2.setLayout(null);

jPanel2.setBorder(new LineBorder(new java.awt.Color(0,0,0), 1,

false));

{

dance = new JCheckBox();

jPanel2.add(dance);

dance.setText("\u8df3\u821e");

dance.setBounds(37, 9, 68, 21);

}

{

sing = new JCheckBox();

jPanel2.add(sing);

sing.setText("\u5531\u6b4c");

sing.setBounds(37, 37, 68, 21);

}

{

readbook = new JCheckBox();

jPanel2.add(readbook);

readbook.setText("\u9605\u8bfb");

readbook.setBounds(37, 71, 68, 21);

}

{

selectAll = new JButton();

jPanel2.add(selectAll);

selectAll.setText("\u5168\u9009");

selectAll.setBounds(176, 13, 77, 24);

selectAll.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent evt) {

Component[] cp=jPanel2.getComponents();

for(Component c:cp){

if(c instanceof JCheckBox){

JCheckBox jb=(JCheckBox)c;

jb.setSelected(true);

}

}

}

});

}

{

notSelectAll = new JButton();

jPanel2.add(notSelectAll);

notSelectAll.setText("\u5168\u4e0d\u9009");

notSelectAll.addActionListener(new ActionListener(){

@Override

public void actionPerformed(ActionEvent arg0) {

// TODO Auto-generated method stub

Component[] cp=jPanel2.getComponents();

for(Component c:cp){

if(c instanceof JCheckBox){

JCheckBox jb=(JCheckBox)c;

jb.setSelected(false);

}

}

}

});

notSelectAll.setBounds(176, 41, 88, 24);

}

{

reverseSelect = new JButton();

jPanel2.add(reverseSelect);

reverseSelect.setText("\u53cd\u9009");

reverseSelect.addActionListener(new ActionListener(){

@Override

public void actionPerformed(ActionEvent arg0) {

// TODO Auto-generated method stub

Component[] cp=jPanel2.getComponents();

for(Component c:cp){

if(c instanceof JCheckBox){

JCheckBox jb=(JCheckBox)c;

jb.setSelected(!jb.isSelected());

}

}

}

});

reverseSelect.setBounds(176, 70, 77, 24);

}

}

{

Vectorvect=new

Vector();

for(int i=1980;i<2010;i++){

vect.add(i);

}

ComboBoxModel yearListModel = new DefaultComboBoxModel(vect);

yearList = new JComboBox();

getContentPane().add(yearList);

yearList.setModel(yearListModel);

yearList.setBounds(263, 50, 73, 24);

yearList.addItemListener(new ItemListener(){

@Override

public void itemStateChanged(ItemEvent arg0) {

int year=(Integer)yearList.getSelectedItem();

int month=(Integer)monthList.getSelectedItem();

loadDays(year,month);

}

});

}

{

Vectorvect=new

Vector();

for(int i=1;i<13;i++){

vect.add(i);

}

ComboBoxModel monthListModel = new

DefaultComboBoxModel(vect);

monthList = new JComboBox();

getContentPane().add(monthList);

monthList.setModel(monthListModel);

monthList.addItemListener(new ItemListener(){

@Override

public void itemStateChanged(ItemEvent arg0) {

// TODO Auto-generated method stub

int year=(Integer)yearList.getSelectedItem();

int month=(Integer)monthList.getSelectedItem();

loadDays(year,month);;

}

});

monthList.setBounds(365, 50, 75, 24);

}

{

dayList = new JComboBox();

getContentPane().add(dayList);

dayList.setBounds(460, 50, 79, 24);

}

pack();

this.setSize(653, 468);

} catch (Exception e) {

e.printStackTrace();

}

}

private

ButtonGroup getSexGroup() {

if(sexGroup == null) {

sexGroup = new ButtonGroup();

}

return sexGroup;

}

private void

loadDays(int year,int month){

days=0;

switch(month){

case 1: case 3: case 5: case 7: case 8: case 10: case 12:

days=31;

break;

case 4: case 6: case 9: case 11:

days=30;

break;

case 2:

if(year@0==0||year%4==0&&year0!=0)

days=29;

else

days=28;

break;

}

Vectorvect=new

Vector();

for(int i=1;i<=days;i++){

vect.add(i);

}

ComboBoxModel dayListModel = new DefaultComboBoxModel(vect);

dayList.setModel(dayListModel);

}

}

创建一个Conn的连接类

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.ArrayList;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.PreparedStatement;

import com.mysql.jdbc.ResultSet;

public class Conn {

private

ArrayList als=new

ArrayList();

public

ArrayList getAls() {

return als;

}

private

Connection conn=null;

private

PreparedStatement ppst=null;

private

ResultSet rs=null;

//创建一个连接数据库服务器的构造方法

public

Conn(){

initial();

createAls();

}

private void

initial(){

//尝试加载驱动包

try {

Class.forName("com.mysql.jdbc.Driver");

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

System.out.println("没有找到驱动包");

}

//创造连接

//nap 用来说明是那个数据库  就是数据库的名称

//uap 用来说明是数据库中那个表

try {

conn=(Connection)

DriverManager.getConnection("jdbc:mysql://localhost/nap","root","root");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

//创建查询的结果

public void

createAls(){

String sql="select * from

uap";

try {

ppst=(PreparedStatement) conn.prepareStatement(sql);

rs=(ResultSet) ppst.executeQuery();

while(rs.next()){

Uap us=new Uap();

us.setUid(rs.getInt(1));

us.setName(rs.getString(2));

us.setPwd(rs.getString(3));

us.setSex(rs.getString(4));

us.setBrith(rs.getString(5));

us.setHobby(rs.getString(6));

us.setDetails(rs.getString(7));

als.add(us);

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

//创建插入方法

public int insert(String name,String password,String sex,String

birth,String hobby,String details){

int row=0;

String sql="insert into

uap(name,pwd,sex,birth,hobby,details)

values(?,?,?,?,?,?)";

try {

ppst=(PreparedStatement) conn.prepareStatement(sql);

ppst.setString(1, name);

ppst.setString(2, password);

ppst.setString(3, sex);

ppst.setString(4, birth);

ppst.setString(5, hobby);

ppst.setString(6, details);

row=ppst.executeUpdate();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return row;

}

public void

closeAll(){

try {

if(rs!=null)

rs.close();

if(ppst!=null)

ppst.close();

if(conn!=null)

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}