packagecaoning;
importjava.sql.*;
publicclasscaoning{
publicstaticvoidmain(String[]args){
Connectioncon=null;
Statementsql=null;
ResultSetrs=null;
try{
Class.forName(\"com.mysql.jdbc.Driver\");
}
catch(ClassNotFoundExceptione){
e.printStackTrace();
System.out.println(\"gffdg\");
}
//
try{
con=DriverManager.getConnection(\"jdbc:mysql://localhost:3306/caoning\",\"root\",\"168578\");
sql=con.createStatement();
//rs=sql.executeQuery(\"select*fromchengji\");
sql.executeUpdate(\"insertintochengji(number,name,subject,score)values(\'2009213877\',\'刘台南\',\'体育\',90)\");
System.out.println(\"测试!!!\");
while(rs.next()){
Stringstudentnumber=rs.getString(1);
System.out.println(\"学号:\"studentnumber);
Stringname=rs.getString(2);
System.out.println(\"姓名:\"name);
Stringkemu=rs.getString(3);
System.out.println(\"科目:\"kemu);
intscore=rs.getInt(4);
System.out.println(\"分数:\"score);
}
con.close();
}
catch(SQLExceptione){}
}
} |