java_student.txt

学生信息管理系统 学生信息管理系统 学生信息管理系统

     mt_sdorm.setText(""); 
     mt_address.setText(""); 
     return; 
   } 
   } 
   if(e.getSource() == m_DelBtn)   //删除按钮动作 
   { 
   if(selIndex == 0) 
   { 
     JOptionPane.showMessageDialog(null, "     请选中要删除的学生信息所在行！！ ", "提示", 1); 
     return; 
   } 
   if(DeleteSQL()) 
   { 
     JOptionPane.showMessageDialog(null, "     删除成功 ", "提示", 1); 
     mt_sno.setText("");//清空文本域 
     mt_sname.setText(""); 
     mt_ssex.setText(""); 
     mt_sage.setText(""); 
     mt_sdorm.setText(""); 
     mt_address.setText(""); 
     return; 
   } 
   else 
   { 
     JOptionPane.showMessageDialog(null, "     删除失败，请重试！！ ", "提示", 1); 
     mt_sno.setText("");//清空文本域 
     mt_sname.setText(""); 
     mt_ssex.setText(""); 
     mt_sage.setText(""); 
     mt_sdorm.setText(""); 
     mt_address.setText(""); 
     return; 
     
   } 
   } 
   if(e.getSource() == n_searchBtn)   //查询按钮动作 
   { 
   if(!SearchSQL()) 
   { 
     JOptionPane.showMessageDialog(null, "         无查询结果!\n确认输入了关键字或尝试其他关键字！！ ", "提示", 1); 
     n_entersearch.setText(""); 
     return; 
   } 
   else 
   { 
     n_entersearch.setText(""); 
     int count = mm.getRowCount(); 
     JOptionPane.showMessageDialog(null, "     查询到"+count+"条结果！！ ", "提示", 1); 
       return; 
   } 
   } 
   if(e.getSource() == DispAllBtn)//显示表中所有数据 
   { 
   ClearTable(); 
   SelectInfoSQL();   
   } 
   if(e.getSource() == ClearTableBtn)//清空表格中数据 
   ClearTable(); 
} 
boolean SelectInfoSQL()   //查询数据库中表中内容添加到列表中 
{ 
   String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动 
   String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=JavaTest "; //连接服务器和数据库sample 
   String userName = "sa"; //默认用户名 
   String userPwd = "songyuejie"; //密码 
   String sql = " select * from 学生信息 order by 学号 asc"; 
   
   Connection dbConn; 
   
   try { 
   Class.forName(driverName); 
   dbConn = DriverManager.getConnection(dbURL, userName, userPwd); 
   
   //通过Statement查询记录 
   Statement stmt = dbConn.createStatement(); 
   //执行语句 
   ResultSet rs = stmt.executeQuery(sql); 
   while(rs.next()){ 
     String sno = (String)rs.getString("学号"); 
     String sname = rs.getString("姓名"); 
     String ssex = rs.getString("性别"); 
     String sage = rs.getString("年龄"); 
     String sdorm = rs.getString("宿舍"); 
     String address = rs.getString("家庭住址"); 
     String[] All ={sno,sname,ssex,sage,sdorm,address}; 
     mm.addRow(All);     
   } 
   table.setModel(mm); 
   return true; 
   
   } catch (Exception e) { 
   e.printStackTrace(); 
   return false; 
   } 
} 
void getContent()//获取所有文本框内容以备调用 
{ 
   a_sno = lt_sno.getText();//添加部分 
   a_sname = lt_sname.getText(); 
   a_ssex = lt_ssex.getText(); 
   a_sage = lt_sage.getText(); 
   a_sdorm = lt_sdorm.getText(); 
   a_address = lt_address.getText(); 
   
   s_content = n_entersearch.getText();//查询部分 
   s_combobox = (String)nc_select.getSelectedItem(); 
   
   d_sno = mt_sno.getText();//删除修改部分 
   d_sname = mt_sname.getText(); 
   d_ssex = mt_ssex.getText(); 
   d_sage = mt_sage.getText(); 
   d_sdorm = mt_sdorm.getText(); 
   d_address = mt_address.getText(); 
} 
void setContent()//点击列的时候将数据添加到删除信息的文本框中用于修改删除操作 
{ 
   int selCount = table.getSelectedRowCount(); 
   if(selCount == 1) 
   { 
   selIndex = table.getSelectedRow();//获得选中的行号 
   String sno = (String)table.getValueAt(selIndex,0);//获得该行的列值 
   String sname = (String)table.getValueAt(selIndex,1); 
   String ssex = (String)table.getValueAt(selIndex,2); 
   String sage = (String)table.getValueAt(selIndex,3); 
   String sdorm = (String)table.getValueAt(selIndex,4); 
   String address = (String)table.getValueAt(selIndex,5); 
   mt_sno.setText(sno);//添加到相应文本域 
   mt_sname.setText(sname); 
   mt_ssex.setText(ssex); 
   mt_sage.setText(sage); 
   mt_sdorm.setText(sdorm); 
   mt_address.setText(address); 
   repaint(); 
   } 
} 
boolean AddSQL() 
{ 
   String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动 
   String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=JavaTest "; //连接服务器和数据库sample 
   String userName = "sa"; //默认用户名 
   String userPwd = "songyuejie"; //密码 
   getContent(); 
   String sql = "insert into 学生信息 values('"+a_sno+"','"+a_sname+"','"+a_ssex+"','"+a_sage+"','"+a_sdorm+"','"+a_address+"')   "; 
   //判断是否输入了所有要添加的内容 
   if(a_sno.length() == 0 || a_sname.length() == 0 || a_ssex.length() == 0 || a_sage.length() ==0 || a_sdorm.length() == 0 || a_address.length() ==0) 
   return false; 
   else 
   { 
   Connection dbConn; 
   
   try { 
   Class.forName(driverName); 
   dbConn = DriverManager.getConnection(dbURL, userName, userPwd); 
   
   //通过Statement查询记录 
   Statement stmt = dbConn.createStatement(); 
   //执行语句 
   stmt.execute(sql); 
   return true; 
   }catch (Exception e) { 
   e.printStackTrace(); 
   return false; 
   } 
   } 
}//添加数据查询SQL 
boolean SearchSQL()//查询数据SQL 
{ 
   String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动 
   String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=JavaTest "; //连接服务器和数据库sample 
   String userName = "sa"; //默认用户名 
   String userPwd = "songyuejie"; //密码 
   getContent(); 
   String sql = "select * from 学生信息 where   "+s_combobox+" LIKE '%"+s_content+"%' ";//模糊搜索 
   if(s_content.length() == 0)//判断是否输入了数据 
       return false; 
   else 
   { 
   Connection dbConn; 
   
   try { 
   Class.forName(driverName); 
   dbConn = DriverManager.getConnection(dbURL, userName, userPwd); 
   
   //通过Statement查询记录 
   Statement stmt = dbConn.createStatement(); 
   //执行语句 
   ResultSet rs = stmt.executeQuery(sql); 
   ClearTable(); 
   while(rs.next()){ 
     String sno = (String)rs.getString("学号"); 
     String sname = rs.getString("姓名"); 
     String ssex = rs.getString("性别"); 
     String sage = rs.getString("年龄"); 
     String sdorm = rs.getString("宿舍"); 
     String address = rs.getString("家庭住址"); 
     String[] All ={sno,sname,ssex,sage,sdorm,address}; 
     mm.addRow(All); 
   } 
   table.setModel(mm); 
   return true; 
   }catch (Exception e) { 
   e.printStackTrace(); 
   return false; 
   } 
   
   } 
} 
boolean AlterSQL()//修改数据SQL 
{ 
   String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动 
   String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=JavaTest "; //连接服务器和数据库sample 
   String userName = "sa"; //默认用户名 
   String userPwd = "songyuejie"; //密码 
   getContent(); 
   String sql = "update 学生信息 set 姓名='"+d_sname+"',性别='"+d_ssex+"',年龄='"+d_sage+"',宿舍='"+d_sdorm+"',家庭住址='"+d_address+"' where 学号='"+d_sno+"' ";//修改数据 
   
   Connection dbConn; 
   
   try { 
   Class.forName(driverName); 
   dbConn = DriverManager.getConnection(dbURL, userName, userPwd); 
   
   //通过Statement查询记录 
   Statement stmt = dbConn.createStatement(); 
   //执行语句 
   stmt.execute(sql); 
   ClearTable();//清除表格中数据 
   SelectInfoSQL();//加入新的修改过的数据 
   return true; 
   
   } catch (Exception e) { 
   e.printStackTrace(); 
   return false; 
   } 
   
} 
boolean DeleteSQL() 
{ 
   String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动 
   String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=JavaTest "; //连接服务器和数据库sample 
   String userName = "sa"; //默认用户名 
   String userPwd = "songyuejie"; //密码 
   getContent(); 
   String sql ="delete from 学生信息 where 学号 = '"+d_sno+"'"; 
   
   Connection dbConn; 
   
   try { 
   Class.forName(driverName); 
   dbConn = DriverManager.getConnection(dbURL, userName, userPwd); 
   
   //通过Statement查询记录 
   Statement stmt = dbConn.createStatement(); 
   //执行语句 
   stmt.execute(sql); 
   mm.removeRow(selIndex);//删除过后同时删除表中相应行 
   selIndex = 0;//选中标志清零，再删除时需选择行 
   
   return true; 
   
   } catch (Exception e) { 
   e.printStackTrace(); 
   return false; 
   } 
} 
void ClearTable()   //清除table中的数据，用于查询显示查询的数据 
{ 
   mm.setRowCount(0); 
} 
}