📄 stuaddquerysysapp4.java
字号:
//对表studentbase和studentaddress中的记录根据输入的学号进行删除
void deleteButton_actionPerformed(ActionEvent e){
//处理deleteButton(删除按钮)的ActionEvent
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //实例化JDBC-ODBC桥的驱动
String url = "jdbc:odbc:student"; //设置连接字符串
connection = DriverManager.getConnection(url); //连接数据库
statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select * from studentbase where 学号 = "+Integer.parseInt
(stunumField.getText())+"";
rSet = statement.executeQuery(sql);
if(rSet.next()==false){//判断数据库中是否有要删除的记录，如没有则显示提示框
JOptionPane msg = new JOptionPane();
JOptionPane.showMessageDialog(StuAddQuerySysFrame.this,
"数据库中没有您删除的学号","数据库中没有您删除的学号！",1);
}
else{
String sql1 = "delete from studentbase where 学号="+Integer.parseInt
(stunumField.getText())+"";
statement.executeUpdate(sql1);
//删除studentbase表中对应学号的数据记录
String sql2="delete from studentaddress where 学号="+Integer.parseInt
(stunumField.getText())+"";
statement.executeUpdate(sql2);//删除studentaddress表中对应学号的数据记录
stunumField.setText(""); //清空信息框
nameField.setText("");
ageField.setText("");
sexField.setText("");
departmentField.setText("");
teleField.setText("");
emailField.setText("");
}
}
catch(SQLException ex){ //捕捉异常
System.out.println("\nERROR:-----SQLException-----\n");
while(ex!=null){
System.out.println("Message:"+ex.getMessage());
System.out.println("SQLState:"+ex.getSQLState());
System.out.println("ErrorCode:"+ex.getErrorCode());
ex = ex.getNextException();
}
}
catch(Exception ex){
ex.printStackTrace();
}
finally{
try{
if(statement!=null){
statement.close(); //关闭Statement接口实例
}
if(connection!=null){
connection.close(); //关闭Connection接口实例
}
}
catch(SQLException ex){
System.out.println("\nERROR:-----SQLException-----\n");
System.out.println("Message:"+ex.getMessage());
System.out.println("SQLState:"+ex.getSQLState());
System.out.println("ErrorCode:"+ex.getErrorCode());
}
}
}
//对表studentbase和表studentaddress中记录根据在各文本框中的输入值进行修改
void refreshButton_actionPerformed(ActionEvent e){
//处理refreshButton(修改按钮)的ActionEvent
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //实例化JDBC-ODBC桥的驱动
String url = "jdbc:odbc:student"; //设置连接字符串
connection = DriverManager.getConnection(url);//连接数据库
statement = connection.createStatement();//创建Statement接口对象
String sql1 =" update studentbase set 姓名='"+nameField.getText()+"',年龄="
+ Integer.parseInt(ageField.getText())+",性别='"+sexField.getText()+"',系别='"
+departmentField.getText()+"' where 学号="+Integer.parseInt(stunumField.getText())+" ";
statement.executeUpdate(sql1); //更新studentbase表中输入学号的记录
String sql2="update studentaddress set 电话='"+teleField.getText()+"',email 地址='"
+emailField.getText()+"' where 学号="+Integer.parseInt(stunumField.getText())+" ";
statement.executeQuery(sql2); // 更新studentbase表中输入学号的记录
stunumField.setText(""); //清空信息框
nameField.setText("");
ageField.setText("");
sexField.setText("");
departmentField.setText("");
teleField.setText("");
emailField.setText("");
}
catch(SQLException ex){ //捕捉异常
System.out.println("\nERROR:-----SQLException-----\n");
while(ex!=null){
System.out.println("Message:"+ex.getMessage());
System.out.println("SQLState:"+ex.getSQLState());
System.out.println("ErrorCode:"+ex.getErrorCode());
ex = ex.getNextException();
}
}
catch(Exception ex){
ex.printStackTrace();
}
finally{
try{
if(statement!=null) {
statement.close(); //关闭Statement接口实例
}
if(connection!=null) {
connection.close(); //关闭Connection接口实例
}
}
catch(SQLException ex){
System.out.println("\nERROR:-----SQLException-----\n");
System.out.println("Message:"+ex.getMessage());
System.out.println("SQLState:"+ex.getSQLState());
System.out.println("ErrorCode:"+ex.getErrorCode());
}
}
}
//按照输入的学号，执行表studentbase、studentaddress的联合查询语句
void stunumqueryButton_actionPerformed(ActionEvent e){
//处理stunumqueryButton(学号查询按钮)的ActionEvent
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //实例化JDBC-ODBC桥的驱动
String url = "jdbc:odbc:student"; //设置连接字符串
connection = DriverManager.getConnection(url); //连接数据库
statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select * from studentbase where 学号 = "+Integer.parseInt
(stunumField.getText())+"";
rSet = statement.executeQuery(sql);
if(rSet.next()==false){//判断数据库中是否有要删除的记录，如没有则显示提示框
JOptionPane msg = new JOptionPane();
JOptionPane.showMessageDialog(StuAddQuerySysFrame.this,
"数据库中没有您查询的学号","数据库中没有您查询的学号！",1);
}
else{
sql = "select studentbase.学号,姓名,年龄,性别,系别,电话,email地址 from studentbase inner join studentaddress on(studentbase.学号=studentaddress.学号) where studentbase.学号="+Integer.parseInt(stunumField.getText())+" ";
ResultSet rs = statement.executeQuery(sql);
//执行表studentbase,studentaddress的联合查询语句，将结果集放入rs中
stunumField.setText(""); //清空输入学号
vector.removeAllElements(); //初始化向量对象
tm.fireTableStructureChanged(); //更新表格内容
while(rs.next()){
Vector rec_vector = new Vector();
rec_vector.addElement(String.valueOf(rs.getInt(1)));
//从结果集中取数据放入向量rec_vector中
rec_vector.addElement(rs.getString(2));
rec_vector.addElement(String.valueOf(rs.getInt(3)));
rec_vector.addElement(rs.getString(4));
rec_vector.addElement(rs.getString(5));
rec_vector.addElement(rs.getString(6));
rec_vector.addElement(rs.getString(7));
vector.addElement(rec_vector); //向量rec_vector加入向量vector中
}
tm.fireTableStructureChanged(); //更新表格，显示向量vector的内容
}
}
catch(SQLException ex){ //捕捉异常
System.out.println("\nERROR:-----SQLException-----\n");
while(ex!=null){
System.out.println("Message:"+ex.getMessage());
System.out.println("SQLState:"+ex.getSQLState());
System.out.println("ErrorCode:"+ex.getErrorCode());
ex = ex.getNextException();
}
}
catch(Exception ex){
ex.printStackTrace();
}
finally{
try{
if(statement!=null){
statement.close(); //关闭Statement接口实例
}
if(connection!=null){
connection.close(); //关闭Connection接口实例
}
}
catch(SQLException ex){
System.out.println("\nERROR:-----SQLException-----\n");
System.out.println("Message:"+ex.getMessage());
System.out.println("SQLState:"+ex.getSQLState());
System.out.println("ErrorCode:"+ex.getErrorCode());
}
}
}
//执行表studentbase.studentaddress的联合查询语句
void allrecordButton_actionPerformed(ActionEvent e){
//处理allrecordButton（全部记录按钮）的ActionEvent
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //实例化JDBC-ODBC桥的驱动
String url = "jdbc:odbc:student"; //设置连接字符串
connection = DriverManager.getConnection(url); //连接数据库
statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select studentbase.学号,姓名,年龄,性别,系别,电话,email地址 from studentbase inner join studentaddress on(studentbase.学号=studentaddress.学号)";
rSet = statement.executeQuery(sql);
//执行表studentbase,studentaddress的联合查询语句，将结果集放入rSet中
vector.removeAllElements(); //初始化向量对象
tm.fireTableStructureChanged(); //更新表格内容
while(rSet.next()){
Vector rec_vector = new Vector();
rec_vector.addElement(String.valueOf(rSet.getInt(1)));
//从结果集中取数据放入向量rec_vector中
rec_vector.addElement(rSet.getString(2));
rec_vector.addElement(String.valueOf(rSet.getInt(3)));
rec_vector.addElement(rSet.getString(4));
rec_vector.addElement(rSet.getString(5));
rec_vector.addElement(rSet.getString(6));
rec_vector.addElement(rSet.getString(7));
vector.addElement(rec_vector); //向量rec_vector加入向量vector中
}
tm.fireTableStructureChanged(); //更新表格，显示向量vector的内容
}
catch(SQLException ex){ //捕捉异常
System.out.println("\nERROR:-----SQLException-----\n");
while(ex!=null){
System.out.println("Message:"+ex.getMessage());
System.out.println("SQLState:"+ex.getSQLState());
System.out.println("ErrorCode:"+ex.getErrorCode());
ex = ex.getNextException();
}
}
catch(Exception ex){
ex.printStackTrace();
}
finally{
try{
if(statement!=null){
statement.close(); //关闭Statement接口实例
}
if(connection!=null){
connection.close(); //关闭Connection接口实例
}
}
catch(SQLException ex){
System.out.println("\nERROR:-----SQLException-----\n");
System.out.println("Message:"+ex.getMessage());
System.out.println("SQLState:"+ex.getSQLState());
System.out.println("ErrorCode:"+ex.getErrorCode());
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -