java 修改mysql编码_Java修改MySQL的操作代码

if(e.getSource()==alter){if((Num.getText().trim()).equals("")||(sName.getText().trim()).equals("")||(cName.getText().trim()).equals("")||(Type1.getText().trim()).equals("...

if (e.getSource() == alter) {

if ((Num.getText().trim()).equals("")

|| (sName.getText().trim()).equals("")

|| (cName.getText().trim()).equals("")

|| (Type1.getText().trim()).equals("")

|| (Grade1.getText().trim()).equals("")

|| (Tnum.getText().trim()).equals("")

|| (Chengj.getText().trim()).equals(""))

JOptionPane.showMessageDialog(null, "请输入信息再点击修改按钮！");

else {

Connection conn = DbUtil.getConnection();

id = Num.getText();

stuname = sName.getText();

coname = cName.getText();

type = Type1.getText();

grade = Grade1.getText();

teanum = Tnum.getText();

mark = Chengj.getText();

String strSQL = "update Mark set stuname='" + stuname

+ "',coname='" + coname + "',type='" + type

+ "',grade='" + grade + "',teanum='" + teanum

+ "',marks='" + mark+ "'" + "where stunum='" + id + "'";

try {

Statement st = conn.createStatement();

st.executeUpdate(strSQL);

} catch (Exception exx) {

JOptionPane.showMessageDialog(null, "数据库中已经存在您要修改的学生记录！");

return;

}

JOptionPane.showMessageDialog(null, "恭喜您，修改成功了！");

}

}

// 查找要修改学生信息功能的实现

if (e.getSource() == sj) {

try {

String strSQL = "select stunum,stuname,coname,type,grade,teanum,mark"

+ " from Mark where stunum= '" + id + "' ";

Connection conn = DbUtil.getConnection();

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery(strSQL);

int count = 0;

while (rs.next()) {

id = rs.getString("stunum");

stuname = rs.getString("stuname");

coname = rs.getString("coname");

type = rs.getString("type");

grade = rs.getString("grade");

teanum = rs.getString("teanum");

mark = rs.getString("mark");

++count;

}

展开