static Connection con=null;
public void SIMS() { }
public void init() { }
static Connection connect() {
try {
Class.forName(\
con = DriverManager.getConnection(\
text1=new JTextField(10); text2=new JTextField(10); text3=new JTextField(10); result=new JTextField(20); button1=new JButton(\追加\button2=new JButton(\查询\button3=new JButton(\删除\button1.addActionListener(this); button2.addActionListener(this); button3.addActionListener(this); add(new JLabel(\学号:\add(text1); add(button1);
add(new JLabel(\姓名:\add(text2); add(button2);
add(new JLabel(\年龄:\add(text3); add(button3); add(result); connect(); init();
setBounds(100,100,350,200); setVisible(true);
setLayout(new FlowLayout());
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
} catch (SQLException e) {
e.printStackTrace(); e.printStackTrace();
} catch (ClassNotFoundException e) {
}
public void select() {
try {
Connection con = connect();
Statement statement = con.createStatement(); String sno;
System.out.println(\请输入要查询的学号：\Scanner cin = new Scanner(System.in); sno = cin.next();
String str = \ResultSet rs = statement.executeQuery(str); while(rs.next()){ }
rs.close(); statement.close();
sno = rs.getString(1);
String sname = rs.getString(2); int age = rs.getInt(3);
System.out.println(sno + \
} catch (SQLException e) { }
e.printStackTrace();
}
public void insert() {
try {
Connection con = connect();
Statement statement = con.createStatement(); String sno, sname; int age;
System.out.println(\请输入学号 姓名 年龄\Scanner cin = new Scanner(System.in); sno = cin.next(); sname = cin.next(); age = cin.nextInt();
String str = \
+ age + \
statement.executeUpdate(str); statement.close(); }
return con;
} catch (SQLException e) {
}
}
}
e.printStackTrace();
public void delete() { }
public void actionPerformed(ActionEvent e) { }
if(e.getSource()==button1)
insert(); select(); delete();
if(e.getSource()==button2) if(e.getSource()==button3) try {
Connection con = connect();
Statement statement = con.createStatement(); String sno;
System.out.println(\请输入要删除的学号\Scanner cin = new Scanner(System.in); sno = cin.next();
String str = \ from t1 where sno=\statement.executeUpdate(str); statement.close();
} catch (SQLException e) { }
e.printStackTrace();
package test2; public class Test2 {
} /**
* @param args */
public static void main(String[] args) {
// TODO Auto-generated method stub SIMS s = new SIMS(); //s.setTitle(\
}
实验题3 向student表连续插入5条记录，使用JDBC事务保证插入操作正确性，若若5条记录插入成功，则操作成功；否则回滚插入操作。
详细代码：
package test3;
import java.sql.*;
public class test3 {
} catch (SQLException e) {
try {
System.out.println(\
public void appendFunction(String[][] records) {
String temp = \try {
ps = conn.prepareStatement(temp); ps.clearBatch();
for (int i = 0; i < records.length; i++) { }
ps.executeBatch(); conn.commit();
System.out.println(\
ps.setString(1, records[i][0]); ps.setString(2, records[i][1]);
ps.setInt(3, Integer.parseInt(records[i][2])); ps.addBatch();
public test3() throws SQLException { }
conn = DriverManager.getConnection(\private Connection conn; private PreparedStatement ps; static { }
try { }
Class.forName(\LServerDriver\e.printStackTrace();
} catch (ClassNotFoundException e) {
相关推荐：
loading