📄 gms.java
字号:
Connection con;
Statement sql;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
sql.executeUpdate("UPDATE grade SET course1="+"'"+course1+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course2="+"'"+course2+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course3="+"'"+course3+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course4="+"'"+course4+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course5="+"'"+course5+"'"+"WHERE cord="+"'"+cord+"'");
JOptionPane.showMessageDialog(null,"录入成绩登陆。");
con.close();
bool=1;
}
catch( SQLException e){}
}
//////////如果不存在则插入新的记录
else if(count==0)
{
Xiugai wangqing=new Xiugai(cord,"666666");
Connection con;
Statement sql;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
JOptionPane.showMessageDialog(null,"你所输入的学生不存在,你是否想插入新的记录?");
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
sql.executeUpdate("INSERT INTO grade (cord,course1,course2,course3,course4,course5)VALUES("+"'"+cord+"'"+","+"'"+course1+"'"+","+"'"+course2+"'"+","+"'"+course3+"'"+","+"'"+course4+"'"+","+"'"+course5+"'"+")");
JOptionPane.showMessageDialog(null,"录入成绩成功。");
con.close();
bool=1;
}
catch( SQLException e){}
}
}
}
//用于信息的数据库连接.
class Select
{
String str1="";
String str2="";
String str3="";
String str4="";
String str5="";
public Select(String cord)
{
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM grade WHERE cord="+"'"+cord+"'");
while(rs.next())
{
str1=rs.getString(2);
str2=rs.getString(3);
str3=rs.getString(4);
str4=rs.getString(5);
str5=rs.getString(6);
}
con.close();
}
catch( SQLException e){}
}
//用于返回信息.
public String return1()
{
return str1;
}
public String return2()
{
return str2;
}
public String return3()
{
return str3;
}
public String return4()
{
return str4;
}
public String return5()
{
return str5;
}
}
///////////用于删除的数据库连接．
class Delete
{
public Delete(String cord)
{
Connection con;
Statement sql;
if(cord.equals(""))
{
JOptionPane.showMessageDialog(null,"请输入删除学生记录的学号！！！");
System.out.print(cord);
}
else
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try {
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
sql.executeUpdate("DELETE FROM grade WHERE cord="+"'"+cord+"'");
JOptionPane.showMessageDialog(null,"删除成功。");
con.close();
}
catch( SQLException e){}
}
}
}
/////创建查询个人信息的类。
class SelectMessage
{
String str1="";
String str2="";
String str3="";
String str4="";
String str5="";
//用于查询用户的基本信息
public SelectMessage(String cord)
{
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM message WHERE name="+"'"+cord+"'");
while(rs.next())
{
str1=rs.getString(1);
str2=rs.getString(2);
str3=rs.getString(3);
str4=rs.getString(4);
str5=rs.getString(7);
}
con.close();
}
catch( SQLException e){}
}
public String return1()
{
return str1;
}
public String return2()
{
return str2;
}
public String return3()
{
return str3;
}
public String return4()
{
return str4;
}
public String return7()
{
return str5;
}
}
/////用户修改信息，连接数据库。
class Reset
{
int bool=0;
public Reset(String cord,String name,String password,String jianjie)
{
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
sql.executeUpdate("UPDATE message SET 姓名="+"'"+name+"'"+"WHERE name="+"'"+cord+"'");
sql.executeUpdate("UPDATE message SET password="+"'"+password+"'"+"WHERE name="+"'"+cord+"'");
sql.executeUpdate("UPDATE message SET 个人简介="+"'"+jianjie+"'"+"WHERE name="+"'"+cord+"'");
JOptionPane.showMessageDialog(null,"修改成功");
bool=1;
con.close();
}
catch(SQLException e){}
}
public int returns()
{
return bool;
}
}
/////当插入新的记录时,需要修改学生信息表的内容.
class Xiugai
{
public Xiugai(String cord, String password )
{
Connection con;
Statement sql;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDirver");
}
catch(ClassNotFoundException e){}
try
{
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
sql.executeUpdate("INSERT INTO message (name,password)VALUES("+"'"+cord+"'"+","+"'"+password+"'"+")");
con.close();
}
catch(SQLException e){}
}
}
class Insert5
{
public Insert5( String cord,String course6,String course7,String course8,String course9,String course10,String course11,String course12,String course13,String course14,String course15,String course16,String course17,String course18,String course19,String course20)
{
Connection con;
Statement sql;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
sql.executeUpdate("UPDATE grade SET course6="+"'"+course6+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course7="+"'"+course7+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course8="+"'"+course8+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course9="+"'"+course9+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course10="+"'"+course10+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course11="+"'"+course11+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course12="+"'"+course12+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course13="+"'"+course13+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course14="+"'"+course14+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course15="+"'"+course15+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course16="+"'"+course16+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course17="+"'"+course17+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course18="+"'"+course18+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course19="+"'"+course19+"'"+"WHERE cord="+"'"+cord+"'");
sql.executeUpdate("UPDATE grade SET course20="+"'"+course20+"'"+"WHERE cord="+"'"+cord+"'");
JOptionPane.showMessageDialog(null,"录入成绩登陆。");
con.close();
}
catch( SQLException e){}
}
}
////////用于查询个人的选修课及其它成绩.
class Select21
{
String str1="";
String str2="";
String str3="";
String str4="";
String str5="";
String str6="";
String str7="";
String str8="";
String str9="";
String str10="";
String str11="";
String str12="";
String str13="";
String str14="";
String str15="";
public Select21(String cord)
{
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
con=DriverManager.getConnection("jdbc:odbc:wangqingbo","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM grade WHERE cord="+"'"+cord+"'");
while(rs.next())
{
str1=rs.getString(7);
str2=rs.getString(8);
str3=rs.getString(9);
str4=rs.getString(10);
str5=rs.getString(11);
str6=rs.getString(12);
str7=rs.getString(13);
str8=rs.getString(14);
str9=rs.getString(15);
str10=rs.getString(16);
str11=rs.getString(17);
str12=rs.getString(18);
str13=rs.getString(19);
str14=rs.getString(20);
str15=rs.getString(21);
}
con.close();
}
catch( SQLException e){}
}
//用于返回查询的成绩.
public String return1()
{
return str1;
}
public String return2()
{
return str2;
}
public String return3()
{
return str3;
}
public String return4()
{
return str4;
}
public String return5()
{
return str5;
}
public String return6()
{
return str6;
}
public String return7()
{
return str7;
}
public String return8()
{
return str8;
}
public String return9()
{
return str9;
}
public String return10()
{
return str10;
}
public String return11()
{
return str11;
}
public String return12()
{
return str12;
}
public String return13()
{
return str13;
}
public String return14()
{
return str14;
}
public String return15()
{
return str15;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -