学生管理系统(JAVA-Mysql)

import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.ButtonGroup;
import javax.swing.JOptionPane;

import com.mysql.jdbc.Statement;

public class system extends javax.swing.JFrame {

static int m_Level = -1;
public system() {
super("登录系统");
initComponents();
//然后设置你编写的窗口的初始位置，也就是在中间，
int width = Toolkit.getDefaultToolkit().getScreenSize().width;
int height = Toolkit.getDefaultToolkit().getScreenSize().height;
this.setLocation(width / 2 - 200, height / 2 - 150);
}

@SuppressWarnings("unchecked")
private void initComponents() {

jLabel1 = new javax.swing.JLabel();
jRadioButton1 = new javax.swing.JRadioButton();
jRadioButton2 = new javax.swing.JRadioButton();
jRadioButton3 = new javax.swing.JRadioButton();
jLabel2 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jLabel3 = new javax.swing.JLabel();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jPassword = new javax.swing.JPasswordField();

ButtonGroup bg = new ButtonGroup();
bg.add(jRadioButton1);
bg.add(jRadioButton2);
bg.add(jRadioButton3);
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

jLabel1.setFont(new java.awt.Font("宋体", 0, 36)); // NOI18N
jLabel1.setForeground(new java.awt.Color(0, 0, 0));
jLabel1.setText("学生信息管理系统");
//jLabel1.
jRadioButton1.setForeground(new java.awt.Color(0, 0, 0));
jRadioButton1.setText("学生");
jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jRadioButton1ActionPerformed(evt);
}
});

jRadioButton2.setForeground(new java.awt.Color(0, 0, 0));
jRadioButton2.setText("老师");
jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jRadioButton2ActionPerformed(evt);
}
});

jRadioButton3.setForeground(new java.awt.Color(0, 0, 0));
jRadioButton3.setText("管理员");
jRadioButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jRadioButton3ActionPerformed(evt);
}
});
jLabel2.setFont(new java.awt.Font("宋体", 0, 24)); // NOI18N
jLabel2.setForeground(new java.awt.Color(0, 0, 0));
jLabel2.setText("帐号：");

jLabel3.setFont(new java.awt.Font(

"宋体", 0, 24)); // NOI18N
jLabel3.setForeground(new java.awt.Color(0, 0, 0));
jLabel3.setText("密码：");

jButton1.setFont(new java.awt.Font("宋体", 0, 18)); // NOI18N
jButton1.setForeground(new java.awt.Color(0, 0, 0));
jButton1.setText("确定");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});

jButton2.setFont(new java.awt.Font("宋体", 0, 18)); // NOI18N
jButton2.setForeground(new java.awt.Color(0, 0, 0));
jButton2.setText("取消");
jButton2.addActionListener(new java.awt.event.ActionListener()
{
public void actionPerformed(java.awt.event.ActionEvent evt)
{
jButton1ActionPerformed(evt);
}
});

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(115, 115, 115)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addComponent(jRadioButton1)
.addGap(62, 62, 62)
.addComponent(jRadioButton2)
.addGap(54, 54, 54)
.addComponent(jRadioButton3))
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 294, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(19, 19, 19)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jButton1)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jLabel3, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(layout.createParallelGroup(jav

ax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jTextField1)
.addComponent(jPassword, javax.swing.GroupLayout.DEFAULT_SIZE, 176, Short.MAX_VALUE))
.addComponent(jButton2))))
.addContainerGap(93, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(18, 18, 18)
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(https://www.doczj.com/doc/d91797374.html,ponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jRadioButton1)
.addComponent(jRadioButton2)
.addComponent(jRadioButton3))
.addGap(22, 22, 22)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(32, 32, 32)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jPassword, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(https://www.doczj.com/doc/d91797374.html,ponentPlacement.RELATED, 55, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1)
.addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(53, 53, 53))
);

pack();
}//

private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {
m_Level = 0;//学生
}
private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {
m_Level = 1;//
}
private void jRadioButton3ActionPerformed(java.awt.event.ActionEvent evt) {
m_Level = 2;//
}
//连接MySQL驱动
public void ConnectToMySQL()
{
try{

Class.forName("com.mysql.jdbc.Driver"); //加载MYSQL JDBC驱动程序
System.out.println("Success loading Mysql Driver!");
}
catch (Exception se)
{
System.out.print("Error loading Mysql Driver!");
JOptionPane.show

MessageDialog(null,se.getMessage());
}
}
//连接到数据库
public Connection getConnection(String dbName)
{
try
{
String mysql = "jdbc:mysql://localhost:3306/";
mysql += dbName;
mysql += "?useUnicode=true&characterEncoding=GBK";
Connection con = DriverManager.getConnection(mysql,"root","5564268");
return con;
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
return null;
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{
if(evt.getSource()==jButton1)
{
String userid , password;
userid = jTextField1.getText();System.out.println(userid);
// password = jTextField2.getText();
password = jPassword.getText();// System.out.println(password);
ConnectToMySQL();//连接到数据库
Connection con = getConnection("stusystem");
String sqlTable = "select * from ";
if(con==null)
{
return;
}
if(m_Level==-1)
{
JOptionPane.showMessageDialog(null,"请选择登陆身份");
return;
}
if(m_Level==0)//学生
{
// sqlTable += "stu_login where ID = '"+userid+"' and Pwd = '"+password+"' ";
sqlTable += "stu_login";
}
else if(m_Level == 1)//教师
{
//sqlTable += "tch_login where ID = '"+userid+"' and Pwd = '"+password+"' ";
sqlTable += "tch_login" ;
}
else if(m_Level == 2)//管理员
{
//sqlTable += "sys where ID = '"+userid+"' and Pwd = '"+password+"' ";
sqlTable += "sys";
}
try
{
Statement stmt = (Statement) con.createStatement();
ResultSet rs = stmt.executeQuery(sqlTable);
int row = rs.getRow();
while(rs.next())
{
if((rs.getString("ID").equals(userid))&&(rs.getString("Pwd").equals(password)))
{
this.dispose();
JOptionPane.showMessageDialog(null,"登录成功");
Main main = new Main();
main.m_myconn = con;
main.m_Level1 = m_Level;
main.m_userid = userid;
main.InitMenu();
main.login = this;
main.setVisible(true);
stmt.close();
rs.close();
return;
}

}
JOptionPane.showMessageDialog(null,"登录失败");
stmt.close();
rs.close();
return;
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
else
{
dispose();
//System.exit(0);
}
}
//密码处理事件
private void jPasswordActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}

public static void main(String args[])
{

java.awt.EventQueue.invokeLater(new Runnable()
{

public void run()

{
new system().setVisible(true);
}
});

}

private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JRadioButton jRadioButton1;
private javax.swing.JRadioButton jRadioButton2;
private javax.swing.JRadioButton jRadioButton3;
private javax.swing.JTextField jTextField1;
private javax.swing.JPasswordField jPassword;
// End of variables declaration
}




////////////////////////////////////////////////////////////////////////

import java.awt.Graphics;
import java.awt.Graphics2D;
import java.awt.Image;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;

//import system.MyPanel;

import java.awt.Button;

import com.mysql.jdbc.Statement;

public class Main extends javax.swing.JFrame {

public Main()
{
initComponents();
//然后设置你编写的窗口的初始位置，也就是在中间，
this.setSize(560,400);
int width = Toolkit.getDefaultToolkit().getScreenSize().width;
int height = Toolkit.getDefaultToolkit().getScreenSize().height;
this.setLocation(width / 2 - 200, height / 2 - 150);
}
@SuppressWarnings("unchecked")
private void initComponents() {
jMenuUpdate = new javax.swing.JMenuBar();
jMenu1 = new javax.swing.JMenu();
jMenu注销 = new javax.swing.JMenuItem();
jMenu退出 = new javax.swing.JMenuItem();
jMenuMyCourse = new javax.swing.JMenu();
jSeparator1 = new javax.swing.JPopupMenu.Separator();
jMenuChoose_Course = new javax.swing.JMenuItem();
jMenuMyGrade = new javax.swing.JMenuItem();
jSeparator3 = new javax.swing.JPopupMenu.Separator();
jMenuItem6 = new javax.swing.JMenuItem();
jMenu7 = new javax.swing.JMenu();
jMenuStuInfo = new javax.swing.JMenuItem();
jMenuStuGrade = new javax.swing.JMenuItem();
jSeparator2 = new javax.swing.JPopupMenu.Separator();
jMenuAddGrade = new javax.swing.JMenuItem();
jMenuSys = new javax.swing.JMenu();
jMenuSys_StuInfo = new javax.swing.JMenu();
jMenuAllStu = new javax.swing.JMenuItem();
jMenuAddStu = new javax.swing.JMenuItem();
jMenuModify = new javax.swing.JMenuItem();
jMenuTch = new javax.swing.JMenu();
jMenuAllTchInfo = new javax.swing.JMenuItem();
jMenuAddTch = new javax.swing.JMenuItem();
jMenuModifyTch = new javax.swing.JMenuItem();
jMenuCourse = new javax.swing.JMenu();
jMen

uAllCourse = new javax.swing.JMenuItem();
jMenuNewCours = new javax.swing.JMenuItem();
jMenuModifyCourse = new javax.swing.JMenuItem();
jMenuDisConnect = new javax.swing.JMenuItem();
jMenuConnect = new javax.swing.JMenuItem();
//this.setIcon(new javax.swing.ImageIcon("C:\\Users\\sheng\\Desktop\\3320946_115242068428_2.jpg"));
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

jMenu1.setForeground(new java.awt.Color(0, 0, 255));
jMenu1.setText("系统");

jMenu注销.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_D, java.awt.event.InputEvent.CTRL_MASK));
jMenu注销.setText("注销");
jMenu注销.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenu注销ActionPerformed(evt);
}
});
jMenu1.add(jMenu注销);

jMenu退出.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_E, java.awt.event.InputEvent.CTRL_MASK));
jMenu退出.setText("退出");
jMenu退出.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenu退出ActionPerformed(evt);
}
});
jMenu1.add(jMenu退出);

jMenuConnect.setText("启用连接");
jMenuConnect.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuConnectActionPerformed(evt);
}
});
jMenu1.add(jMenuConnect);

jMenuDisConnect.setText("断开数据库");
jMenuDisConnect.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuDisConnectActionPerformed(evt);
}
});
jMenu1.add(jMenuDisConnect);
jMenuUpdate.add(jMenu1);

jMenuMyCourse.setText("学生操作");
jMenuMyCourse.add(jSeparator1);

jMenuChoose_Course.setText("我要选课");
jMenuChoose_Course.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuChoose_CourseActionPerformed(evt);
}
});
jMenuMyCourse.add(jMenuChoose_Course);

jMenuMyGrade.setText("我的成绩");
jMenuMyGrade.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuMyGradeActionPerformed(evt);
}
});
jMenuMyCourse.add(jMenuMyGrade);
jMenuMyCourse.add(jSeparator3);

jMenuItem6.setText("我的选课");

jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuItem6ActionPerformed(evt);
}
});
jMenuMyCourse.add(jMenuItem6);

jMenuUpdate.add(jMenuMyCourse);

jMenu7.setText("教师操作");

jMenuStuInfo.setText("学生基本信息");
jMenuStuInfo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuStuInfoActionPerformed(evt);
}
});
jMenu7.add(jMenuStuInfo);

jMenuStuGrade.setText("学生成绩");
jMenuStuGrade.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuStuGradeActionPerformed(evt);
}
});
jMenu7.add(jMenuStuGrade);
jMenu7.add(jSeparator2);

jMenuAddGrade.setText("成绩入库");
jMenuAddGrade.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuAddGradeActionPerformed(evt);
}
});
jMenu7.add(jMenuAddGrade);

jMenuUpdate.add(jMenu7);

jMenuSys.setText("管理员操作");

jMenuSys_StuInfo.setText("学生信息");

jMenuAllStu.setText("查看所有学生信息");
jMenuAllStu.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuAllStuActionPerformed(evt);
}
});
jMenuSys_StuInfo.add(jMenuAllStu);

jMenuAddStu.setText("添加学生");
jMenuAddStu.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuAddStuActionPerformed(evt);
}
});
jMenuSys_StuInfo.add(jMenuAddStu);

jMenuModify.setText("修改学生信息");
jMenuModify.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuModifyActionPerformed(evt);
}
});
jMenuSys_StuInfo.add(jMenuModify);

jMenuSys.add(jMenuSys_StuInfo);

jMenuTch.setText("教师信息");

jMenuAllTchInfo.setText("查看所有教师信息");
jMenuAllTchInfo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuAllTchInfoActionPerformed(evt);
}
});
jMenuTch.add(jMenuAllTchInfo);

jMenuAddTch.setText("新增教师");
jMenuAddTch.addActionListener(new java.awt.even

t.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuAddTchActionPerformed(evt);
}
});
jMenuTch.add(jMenuAddTch);

jMenuModifyTch.setText("修改教师信息");
jMenuModifyTch.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuModifyTchActionPerformed(evt);
}
});
jMenuTch.add(jMenuModifyTch);

jMenuSys.add(jMenuTch);

jMenuCourse.setText("课程信息");

jMenuAllCourse.setText("所有课程信息");
jMenuAllCourse.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuAllCourseActionPerformed(evt);
}
});
jMenuCourse.add(jMenuAllCourse);

jMenuNewCours.setText("新开设课程");
jMenuNewCours.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuNewCoursActionPerformed(evt);
}
});
jMenuCourse.add(jMenuNewCours);

jMenuModifyCourse.setText("修改课程信息");
jMenuModifyCourse.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuModifyCourseActionPerformed(evt);
}
});
jMenuCourse.add(jMenuModifyCourse);

jMenuSys.add(jMenuCourse);

jMenuUpdate.add(jMenuSys);
setJMenuBar(jMenuUpdate);

jScrollPane1 = new javax.swing.JScrollPane();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
pack();
}//
private void InitList()
{
jTable1 = new javax.swing.JTable();

jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] { },new String [] {"课程编号", "课程名称", "分数" }) {
Class[] types = new Class [] {
https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.Integer.class
};
boolean[] canEdit = new boolean [] {
false, false, false
};

public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}

public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
jScrollPane1.setViewportView(jTable1);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADI

NG)
.addGroup(layout.createSequentialGroup()
.addGap(35, 35, 35)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(133, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(15, Short.MAX_VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 327, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);

}
//注销
private void jMenu注销ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
this.dispose();
system login = new system();
login.setVisible(true);
}
//退出
private void jMenu退出ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
this.dispose();
}
//我的成绩
private void jMenuMyGradeActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
if(!m_myconn.isClosed())
{
if(m_Level1==0)
{
String sql = "select https://www.doczj.com/doc/d91797374.html,o,Cname,sc.Grade from course,sc where https://www.doczj.com/doc/d91797374.html,o=https://www.doczj.com/doc/d91797374.html,o and Sno = '"+m_userid+"'";
try
{ this.setSize(520,400);
if(jSend!=null)
jSend.setVisible(false);
if(jFlush!=null)
jFlush.setVisible(false);
InitList();
Statement stmt = (Statement) m_myconn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
String cno=null,cname=null,grade = null;
while(rs.next())
{
if(!rs.getString(1).equals(null))
cno = rs.getString(1).toString();
// System.out.print(cno);
if(!rs.getString(2).equals(null))
cname = rs.getString(2).toString();
// System.out.print(cname);
if(rs.getString(3)!=null)
grade = rs.getString(3).toString();
else
grade = null;
// System.out.println(grade);
DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
model.addRow(new Object[]{cno,cname,grade});
}
stmt.close();
rs.close();

}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}

}
}
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
//我的选课
private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try

{
if(!m_myconn.isClosed())
{
if(m_Level1==0)
{
String sql = "select https://www.doczj.com/doc/d91797374.html,o,https://www.doczj.com/doc/d91797374.html,ame,Ccredit,tch.Tname from sc,course,tch where https://www.doczj.com/doc/d91797374.html,o = https://www.doczj.com/doc/d91797374.html,o and course.Tno = tch.Tno and Sno = '"+m_userid+"'";
try
{
if(jSend!=null)
jSend.setVisible(false);
if(jFlush!=null)
jFlush.setVisible(false);
this.setSize(520,400);
jTable1 = new javax.swing.JTable();
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(35, 35, 35)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(133, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(15, Short.MAX_VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 327, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);

DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
int num = tableModel.getRowCount();
for (int i = 0; i < num; i++)
tableModel.removeRow(0);
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] { },new String [] {"课程编号", "课程名称", "学 时","任课教师" })) ;
jScrollPane1.setViewportView(jTable1);
Statement stmt = (Statement) m_myconn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
String cno=null,cname=null,ccredit = null,tname = null;
while(rs.next())
{
if(!rs.getString(1).equals(null))
cno = rs.getString(1).toString();
//System.out.print(cno);
if(!rs.getString(2).equals(null))
cname = rs.getString(2).toString();
//System.out.print(cname);
if(!rs.getString(3).equals(null))
ccredit = rs.getString(3).toString();
//System.out.print(ccredit);
if(!rs.getString(4).equals(null))
tname = rs.getString(4).toString();
//System.out.print(tname);
DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
model.addRow(new Object[]{cno,cname,ccredit,tname});
}
stmt.close();
rs.close();

}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}

}
}
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
//我要选课
private void jMenuChoose_CourseActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
if(!m_myconn.isClosed())
{
if(m_Level1==0)
{
jSend =new Button("确定");
jSend.setFont(new java.awt.Font("宋体", 0, 18)); // NOI18N
jSend.setForeground(new java.awt.Color(0, 255, 204));
this.add(jSend);
jSend.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
this.getContentPane().add(jSend);
this.setSize(600,400);
jSend.setBounds(500, 60, 80, 50);
jSend.setVisible(true);

jFlush =new Button("刷新");
jFlush.setFont(new java.awt.Font("宋体", 0, 18)); // NOI18N
jFlush.setForeground(new java.awt.Color(0, 255, 204));
this.add(jFlush);
jFlush.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
this.getContentPane().add(jFlush);
this.setSize(600,400);
jFlush.setBounds(500, 250, 80, 50);
jFlush.setVisible(true);

String sql = "select https://www.doczj.com/doc/d91797374.html,o,Cname,Ccredit,tch.Tname from course,tch where course.Tno = tch.Tno and https://www.doczj.com/doc/d91797374.html,o not in (select Cno from sc where Sno = '"+m_userid+"')";
try
{
jTable1 = new javax.swing.JTable();
javax.swing.GroupLayout layout1 = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout1);
layout1.setHorizontalGroup(
layout1.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout1.createSequentialGroup()
.addGap(35, 35, 35)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(133, Short.MAX_VALUE))
);
layout1.setVerticalGroup(
layout1.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout1.createSequentialGroup()
.addContainerGap(15, Short.MAX_VALUE)
.addComponent(jScrollPane1, j

avax.swing.GroupLayout.PREFERRED_SIZE, 327, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
int num = tableModel.getRowCount();
for (int i = 0; i < num; i++)
tableModel.removeRow(0);
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] { },new String [] {"课程编号", "课程名称", "学 时","任课教师","确认选课" }) {
Class[] types = new Class [] {
https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.String.class,https://www.doczj.com/doc/d91797374.html,ng.String.class,https://www.doczj.com/doc/d91797374.html,ng.Boolean.class
};
boolean[] canEdit = new boolean [] {
false, false, false,false,true
};

public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}

public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
jScrollPane1.setViewportView(jTable1);
Statement stmt = (Statement) m_myconn.createStatement();
ResultSet rs = stmt.executeQuery(sql);

while(rs.next())
{
String cno=null,cname=null,ccredit = null,tname = null;
if(!rs.getString(1).equals(null))
cno = rs.getString(1).toString();
//System.out.print(cno);
if(!rs.getString(2).equals(null))
cname = rs.getString(2).toString();
//System.out.print(cname);
if(!rs.getString(3).equals(null))
ccredit = rs.getString(3).toString();
//System.out.print(ccredit);
if(!rs.getString(4).equals(null))
tname = rs.getString(4).toString();
//System.out.print(tname);
DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
model.addRow(new Object[]{cno,cname,ccredit,tname,false});
}
stmt.close();
rs.close();


}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}

}
}
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
//我要选课提交按钮
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

int cols = jTable1.getColumnCount();//列数
int rows = jTable1.getRowCount();//行数
DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
for(int i=0;i{
Boolean cellVal

ue=(Boolean) tableModel.getValueAt(i, 4);// 取单元格数据,row是行号,column是列号
if(cellValue==true)
{
String cno =(String) tableModel.getValueAt(i, 0);// 取单元格数据,row是行号,column是列号
try
{
if(!m_myconn.isClosed())
{
String sql = "insert into sc(Sno,Cno) values('"+m_userid+"','"+cno+"')";
Statement stmt = (Statement) m_myconn.createStatement();
int affect = stmt.executeUpdate(sql);
if(affect==1)
{
JOptionPane.showMessageDialog(null,"添加成功");
}
else
{
JOptionPane.showMessageDialog(null,"添加失败");
}
stmt.close();
}
}
catch(SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
}
}
//刷新
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
jMenuChoose_CourseActionPerformed(evt);
}
//学生信息
private void jMenuStuInfoActionPerformed(java.awt.event.ActionEvent evt)
{
try
{
if(!m_myconn.isClosed())
{
if(m_Level1==1)
{
String sql = "select stu.Sno,Sname,Ssex,Sage,class from stu,sc,course,tch where stu.Sno = sc.Sno and https://www.doczj.com/doc/d91797374.html,o = https://www.doczj.com/doc/d91797374.html,o and course.Tno = tch.Tno and tch.Tno = '"+m_userid+"'";
try
{
if(jSend!=null)
jSend.setVisible(false);
this.setSize(550,400);
jTable1 = new javax.swing.JTable();
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(35, 35, 35)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(133, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(15, Short.MAX_VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 327, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);

DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
int num = tableModel.getRowCount();
for (int i = 0; i < num; i++)
tableModel.removeRow(0);
jTable1.setModel(new javax.swing.table.DefaultTableModel(

new Object [][] { },new String [] {"学 号", "姓 名", "性 别","年 龄"})) ;
jScrollPane1.setViewportView(jTable1);
Statement stmt = (Statement) m_myconn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
String sno=null,sname=null,ssex = null;
int sage = 0;
while(rs.next())
{
if(!rs.getString(1).equals(null))
sno = rs.getString(1).toString();
//System.out.print(sno);

if(!rs.getString(2).equals(null))
sname = rs.getString(2).toString();
//System.out.print(sname);

if(!rs.getString(3).equals(null))
ssex = rs.getString(3).toString();
//System.out.print(ssex);

if(!rs.getString(4).equals(null))
sage = rs.getInt(4);
//System.out.print(sage);


DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
model.addRow(new Object[]{sno,sname,ssex,sage});
}
stmt.close();
rs.close();

}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}

}
}
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}

}
//学生成绩查看
private void jMenuStuGradeActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
if(!m_myconn.isClosed())
{
if(m_Level1==1)
{
String sql = "select stu.Sno,Sname,https://www.doczj.com/doc/d91797374.html,o,Cname,sc.Grade from stu,sc,course,tch where stu.Sno = sc.Sno and https://www.doczj.com/doc/d91797374.html,o = https://www.doczj.com/doc/d91797374.html,o and course.Tno = tch.Tno and sc.Grade IS NOT NULL and tch.Tno = '"+m_userid+"'";
try
{
if(jSend!=null)
jSend.setVisible(false);
this.setSize(550,400);
jTable1 = new javax.swing.JTable();
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(35, 35, 35)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(133, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(15, Short.MAX_

VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 327, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);

DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
int num = tableModel.getRowCount();
for (int i = 0; i < num; i++)
tableModel.removeRow(0);
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] { },new String [] {"学 号", "姓 名", "课程编号","课程名称","成 绩"})) ;
jScrollPane1.setViewportView(jTable1);
Statement stmt = (Statement) m_myconn.createStatement();
ResultSet rs = stmt.executeQuery(sql);

while(rs.next())
{
String sno=null,sname=null,cno = null,cname = null,grade = null;
if(rs.getString(1)!=null)
sno = rs.getString(1).toString();
//System.out.print(sno);

if(rs.getString(2)!=null)
sname = rs.getString(2).toString();
//System.out.print(sname);

if(rs.getString(3)!=null)
cno = rs.getString(3).toString();
//System.out.print(cno);

if(rs.getString(4)!=null)
cname = rs.getString(4).toString();
//System.out.print(cname);
if(rs.getString(5)!=null)
grade = rs.getString(5).toString();
//System.out.print(grade);

DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
model.addRow(new Object[]{sno,sname,cno,cname,grade});
}
stmt.close();
rs.close();

}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}

}
}
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
//成绩入库
private void jMenuAddGradeActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
if(!m_myconn.isClosed())
{
if(m_Level1==1)
{
String sql = "select stu.Sno,Sname,https://www.doczj.com/doc/d91797374.html,o,Cname,sc.Grade from stu,sc,course,tch where stu.Sno = sc.Sno and https://www.doczj.com/doc/d91797374.html,o = https://www.doczj.com/doc/d91797374.html,o and course.Tno = tch.Tno and sc.Grade IS NULL and tch.Tno = '"+m_userid+"'";
try
{
jSend =new Button("提交");
jSend.setFont(new java.awt.Font("宋体", 0, 18)); // NOI18N
jSend.setForeground(new java.awt.Color(0, 255, 204));
this.add(jSend);
jSend.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerfor

med(evt);
}
});
this.getContentPane().add(jSend);
this.setSize(600,400);
jSend.setBounds(500, 60, 80, 50);
jSend.setVisible(true);

jTable1 = new javax.swing.JTable();
javax.swing.GroupLayout layout1 = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout1);
layout1.setHorizontalGroup(
layout1.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout1.createSequentialGroup()
.addGap(35, 35, 35)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(133, Short.MAX_VALUE))
);
layout1.setVerticalGroup(
layout1.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout1.createSequentialGroup()
.addContainerGap(15, Short.MAX_VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 327, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
int num = tableModel.getRowCount();
for (int i = 0; i < num; i++)
tableModel.removeRow(0);
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] { },new String [] {"学生编号", "学生姓名", "课程编号 ","课程名称","成 绩" }) {
Class[] types = new Class [] {
https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.String.class,https://www.doczj.com/doc/d91797374.html,ng.String.class,https://www.doczj.com/doc/d91797374.html,ng.Integer.class
};
boolean[] canEdit = new boolean [] {
false, false, false,false,true
};

public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}

public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
jScrollPane1.setViewportView(jTable1);

Statement stmt = (Statement) m_myconn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
String sno=null,sname=null,cno = null,cname = null;

while(rs.next())
{
if(!rs.getString(1).equals(null))
sno = rs.getSt

ring(1).toString();
//System.out.print(sno);

if(!rs.getString(2).equals(null))
sname = rs.getString(2).toString();
//System.out.print(sname);

if(!rs.getString(3).equals(null))
cno = rs.getString(3).toString();
//System.out.print(cno);

if(!rs.getString(4).equals(null))
cname = rs.getString(4).toString();
//System.out.print(cname);
//if(!rs.getString(5).equals(null))
// grade = rs.getString(5).toString();
// System.out.print(grade);

DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
model.addRow(new Object[]{sno,sname,cno,cname});
}
stmt.close();
rs.close();

}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}

}
}
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
//成绩入库提交按钮
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
int cols = jTable1.getColumnCount();//列数
int rows = jTable1.getRowCount();//行数
DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
int affect = 0;
try
{
if(m_myconn.isClosed())
return;
Statement stmt = null;
for(int i=0;i{
Integer Grade=(Integer) tableModel.getValueAt(i, 4);// 取单元格数据,row是行号,column是列号
System.out.println(Grade);
String sno =(String) tableModel.getValueAt(i, 0);// 取单元格数据,row是行号,column是列号
String cno =(String) tableModel.getValueAt(i, 2);// 取单元格数据,row是行号,column是列号
String sql = "update sc set Grade ='"+Grade+"' where Sno = '"+sno+"' and Cno = '"+cno+"'";
stmt = (Statement) m_myconn.createStatement();
affect += stmt.executeUpdate(sql);
}
stmt.close();
JOptionPane.showMessageDialog(null,"已有 " + affect+" 个学生成绩入库");
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
//修改学生信息
private void jMenuModifyActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
if(!m_myconn.isClosed())
{
if(m_Level1==2)
{
String sql = "select * from stu";
try
{
jSend =new Button("提交");
jSend.setFont(new java.awt.Font("宋体", 0, 18)); // NOI18N
jSend.setForeground(new java.awt.Color(0, 255, 204));
this.add(jSend);
jSend.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
this.getContentPane().add(jSend);
this.setSize(600,400);
jSend.setBounds(500, 60, 80, 50);
jSend.setVisible(true);

jTable1 = new javax.swing.JTable();
javax.swing.GroupLayout layout1 = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout1);
layout1.setHorizontalGroup(
layout1.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout1.createSequentialGroup()
.addGap(35, 35, 35)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(133, Short.MAX_VALUE))
);
layout1.setVerticalGroup(
layout1.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout1.createSequentialGroup()
.addContainerGap(15, Short.MAX_VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 327, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
int num = tableModel.getRowCount();
for (int i = 0; i < num; i++)
tableModel.removeRow(0);
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] { },new String [] {"学生编号", "学生姓名", "性 别 ","年 龄","班 级" }) {
Class[] types = new Class [] {
https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.String.class,https://www.doczj.com/doc/d91797374.html,ng.String.class,https://www.doczj.com/doc/d91797374.html,ng.String.class
};
boolean[] canEdit = new boolean [] {
false, true, true,true,true
};

public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}

public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
jScrollPane1.setViewportView(jTable1);

Statement stmt = (Statement) m_myconn.createStatement();
ResultSet rs = stmt.executeQuery(sql);

while(rs.next())
{
Strin

g sno=null,sname=null,ssex = null,sclass = null;
String age = "";
if(rs.getString(1)!=null)
sno = rs.getString(1).toString();
//System.out.print(sno);

if(rs.getString(2)!=null)
sname = rs.getString(2).toString();
//System.out.print(sname);
if(rs.getString(3)!=null)
ssex = rs.getString(3).toString();
//System.out.print(ssex);
// String sage = rs.getString(4).toString();
if(rs.getString(4)!=null)
age = rs.getString(4).toString();


//System.out.print(sage);
if(rs.getString(5)!=null)
sclass = rs.getString(5).toString();
// System.out.print(sclass);

DefaultTableModel model = (DefaultTableModel) jTable1.getModel();

model.addRow(new Object[]{sno,sname,ssex,age,sclass});
}
stmt.close();
rs.close();

}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}

}
}
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
int cols = jTable1.getColumnCount();//列数
int rows = jTable1.getRowCount();//行数
DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
try
{
if(m_myconn.isClosed())
return;
Statement stmt = null;
int affect = 0;
for(int i=0;i{
String cellValue=(String) tableModel.getValueAt(i, 2);// 取单元格数据,row是行号,column是列号,性别
// System.out.print(cellValue);
if(!((cellValue!="男")&&(cellValue!="女")))
{
JOptionPane.showMessageDialog(null,"性别 存在不合法的字符");
return;
}

else
{
String sno =(String) tableModel.getValueAt(i, 0);// 取单元格数据,row是行号,column是列号
System.out.println(sno);
String sname =(String) tableModel.getValueAt(i, 1);
System.out.println(sname);
String ssex =(String) tableModel.getValueAt(i, 2);
System.out.println(ssex);
Integer sage = 0;
String age = (String)tableModel.getValueAt(i, 3);
if(!age.isEmpty())
sage = Integer.parseInt(age);
System.out.println(sage);
String sclass =(String) tableModel.getValueAt(i, 4);
System.out.println(sclass);
String sql = "update stu set Sname ='"+sname+"',Ssex = '"+ssex+"',Sage = '"+sage+"',Class = '"+sclass+"' where Sno = '"+sno+"'";
stmt = (Statement) m_myconn.createStatement();
affect += stmt.executeUpdate(sql);
}
}
stm

t.close();
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(null,se.getMessage());
}
}

//查看所有学生信息
private void jMenuAllStuActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
if(!m_myconn.isClosed())
{
if(m_Level1==2)
{
String sql = "select Sno,Sname,Ssex,Sage,class from stu";
try
{
if(jSend!=null)
jSend.setVisible(false);
this.setSize(550,400);
jTable1 = new javax.swing.JTable();
javax.swing.GroupLayout layout1 = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout1);
layout1.setHorizontalGroup(
layout1.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout1.createSequentialGroup()
.addGap(35, 35, 35)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(133, Short.MAX_VALUE))
);
layout1.setVerticalGroup(
layout1.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout1.createSequentialGroup()
.addContainerGap(15, Short.MAX_VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 327, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
DefaultTableModel tableModel = (DefaultTableModel) jTable1.getModel();
int num = tableModel.getRowCount();
for (int i = 0; i < num; i++)
tableModel.removeRow(0);
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] { },new String [] {"学生编号", "学生姓名", "性 别 ","年 龄","班 级" }) {
Class[] types = new Class [] {
https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.String.class, https://www.doczj.com/doc/d91797374.html,ng.String.class,https://www.doczj.com/doc/d91797374.html,ng.Integer.class,https://www.doczj.com/doc/d91797374.html,ng.String.class
};
boolean[] canEdit = new boolean [] {
false, false, false,false,false
};

public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}

public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}