java sql2008的增删改查_java访问数据库sql server 增删改查第四篇

zhengjia.java

import javax.swing.JDialog;

import javax.swing.JFrame;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

import java.util.*;

import javax.swing.*;

class zhengjia extends JDialog implements ActionListener

{

JLabel bq1,bq2,bq3,bq4;

JTextField wbk1,wbk2,wbk3,wbk4;

JButton an1,an2;

JPanel mb1,mb2,mb3,mb4;

public zhengjia(Frame fck,String ckm,Boolean msck)

{

super(fck,ckm,msck);

bq1=new JLabel(" 学号 ");

bq2=new JLabel(" 姓名 ");

bq3=new JLabel(" 性别 ");

bq4=new JLabel(" 年龄 ");

wbk1=new JTextField(5);

wbk2=new JTextField(5);

wbk3=new JTextField(5);

wbk4=new JTextField(5);

an1=new JButton("添加");

an1.addActionListener(this);

an1.setActionCommand("tianjia1");

an2=new JButton("取消");

an2.addActionListener(this);

an2.setActionCommand("quxiao");

mb1=new JPanel();

mb2=new JPanel();

mb3=new JPanel();

mb4=new JPanel();

mb1.setLayout(new GridLayout(4,1));

mb2.setLayout(new GridLayout(4,1));

mb1.add(bq1); mb1.add(bq2); mb1.add(bq3);

mb1.add(bq4);

mb2.add(wbk1); mb2.add(wbk2); mb2.add(wbk3);

mb2.add(wbk4);

mb3.add(an1); mb3.add(an2);

this.add(mb1,BorderLayout.WEST);

this.add(mb2);

this.add(mb3,BorderLayout.SOUTH);

this.add(mb4,BorderLayout.EAST);

this.setSize(370,270);

this.setLocation(401,281);

this.setResizable(false);

//this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setVisible(true);

}

public void actionPerformed(ActionEvent e)

{

if(e.getActionCommand().equals("tianjia1"))

{

PreparedStatement ps=null;

Connection ct=null;

ResultSet rs=null;

Statement sm=null;

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

ct=DriverManager.getConnection("jdbc:odbc:sql server");

String ss=("insert into Table_3 values(?,?,?,?)");

ps=ct.prepareStatement(ss);

ps.setString(1,wbk1.getText());

ps.setString(2,wbk2.getText());

ps.setString(3,wbk3.getText());

ps.setString(4,wbk4.getText());

ps.executeUpdate();

this.dispose();

} catch (Exception e2){}

finally

{

try {

if(rs!=null)

{

rs.close();

}

if(ps!=null)

{

ps.close();

}

if(ct!=null)

{

ct.close();

}

} catch (Exception e3){}

}

}

else if(e.getActionCommand().equals("quxiao"))

{

this.dispose();

}

}

}