java增删改查代码(精)
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
con = DriverManager.getConnection("jdbc:odbc:DSStudent","",""; //创建statement
sql = con.createStatement(;
String str1 = t1.getText(;
String str = "select * from T_STUDENT where STUNO='"+str1+"'"; rs = sql.executeQuery(str;
setContentPane(contentPane;
contentPane.setLayout(null;
t1 = new JTextField(;
t1.setFont(new Font("宋体", Font.BOLD, 16;
t1.setBounds(133, 24, 124, 26;
contentPane.add(t1;
while(rs.next({
String name = rs.getString("STUNAME";
String sex = rs.getString(3;
t2.setText(name;
t3.setText(sex;
}
//关闭连接
con.close(;
}catch(SQLException el{
}
JButton button = new JButton("\u67E5\u8BE2";
button.addActionListener(new ActionListener( {
public void actionPerformed(ActionEvent arg0 {
try{
//建立到access的链接
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JScrollPane;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
contentPane.add(lblNewLabel;
try{
//加载Connector关于access的驱动
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver";
}catch(ClassNotFoundException e{
System.out.println(" "+e;
import java.awt.EventQueue;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JTextField;
import wenku.baidu.comavax.swing.JLabel;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
public class test01 extends JFrame {
private JPanel contentPane;
private JTextField t1;
private JTextField t2;
private JTextField t3;
private Connection con;//声明一个连接
private Statement sql;//声明一个statement对象
private ResultSet rs;//声明一个结果集
private PreparedStatement pst;
public void run( {
try {
test01 frame = new test01(;
frame.setVisible(true;
} catch (Exception e {
e.printStackTrace(;
}
}
};
}
/**
* Create the frame.
*/
public test01( {
System.out.println(" "+el;
}
}
};
button.setBounds(10, 84, 93, 23;
contentPane.add(button;
JButton button_1 = new JButton("\u6DFB\u52A0";
button_1.addActionListener(new ActionListener( {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE;
setBounds(100, 100, 516, 467;
contentPane = new JPanel(;
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5;
import javax.swing.JButton;
import java.awt.Font;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
t1.setColumns(10;
JLabel lblNewLabel = new JLabel("\u8BF7\u8F93\u5165\u5B66\u53F7\u67E5\u8BE2\uFF1A";
lblNewLabel.setFont(new Font("宋体", Font.BOLD, 14;
lblNewLabel.setBounds(10, 26, 127, 21;
private JTable table;
private String s[][] = new String[20][3];
/**
* Launch the application.
*/
public static void main(String[] args {
EventQueue.invokeLater(new Runnable( {
sql = con.createStatement(;
String str1 = t1.getText(;
String str = "select * from T_STUDENT where STUNO='"+str1+"'"; rs = sql.executeQuery(str;
setContentPane(contentPane;
contentPane.setLayout(null;
t1 = new JTextField(;
t1.setFont(new Font("宋体", Font.BOLD, 16;
t1.setBounds(133, 24, 124, 26;
contentPane.add(t1;
while(rs.next({
String name = rs.getString("STUNAME";
String sex = rs.getString(3;
t2.setText(name;
t3.setText(sex;
}
//关闭连接
con.close(;
}catch(SQLException el{
}
JButton button = new JButton("\u67E5\u8BE2";
button.addActionListener(new ActionListener( {
public void actionPerformed(ActionEvent arg0 {
try{
//建立到access的链接
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JScrollPane;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
contentPane.add(lblNewLabel;
try{
//加载Connector关于access的驱动
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver";
}catch(ClassNotFoundException e{
System.out.println(" "+e;
import java.awt.EventQueue;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JTextField;
import wenku.baidu.comavax.swing.JLabel;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
public class test01 extends JFrame {
private JPanel contentPane;
private JTextField t1;
private JTextField t2;
private JTextField t3;
private Connection con;//声明一个连接
private Statement sql;//声明一个statement对象
private ResultSet rs;//声明一个结果集
private PreparedStatement pst;
public void run( {
try {
test01 frame = new test01(;
frame.setVisible(true;
} catch (Exception e {
e.printStackTrace(;
}
}
};
}
/**
* Create the frame.
*/
public test01( {
System.out.println(" "+el;
}
}
};
button.setBounds(10, 84, 93, 23;
contentPane.add(button;
JButton button_1 = new JButton("\u6DFB\u52A0";
button_1.addActionListener(new ActionListener( {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE;
setBounds(100, 100, 516, 467;
contentPane = new JPanel(;
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5;
import javax.swing.JButton;
import java.awt.Font;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
t1.setColumns(10;
JLabel lblNewLabel = new JLabel("\u8BF7\u8F93\u5165\u5B66\u53F7\u67E5\u8BE2\uFF1A";
lblNewLabel.setFont(new Font("宋体", Font.BOLD, 14;
lblNewLabel.setBounds(10, 26, 127, 21;
private JTable table;
private String s[][] = new String[20][3];
/**
* Launch the application.
*/
public static void main(String[] args {
EventQueue.invokeLater(new Runnable( {