、获取 #'9 的 !"# 成绩信息。
java 代码:
1. importjava.sql.*;
2. publicclassMySQLExample
3. {
4.
5. staticfinalStringJDBC_DRIVER="com.mysql.jdbc.Driver";
6. staticfinalStringDB_URL="jdbc:mysql://localhost:3306/test?
useSSL=false&serverTimezone=UTC";//Student 是数据库名
7. staticfinalStringUSER="root";
8. staticfinalStringPASS="123456";
9.
10. //添加一行记录
11. publicstaticvoidaddRecord(Connectionconn,Stringsql,Stringna
me,intenglish,intmath,intcomputer)
12. {
13. PreparedStatementps;
14. try
15. {
16. ps=conn.prepareStatement(sql);
17. ps.setString(1,name);
18. ps.setInt(2,english);
19. ps.setInt(3,math);
20. ps.setInt(4,computer);
21. ps.executeUpdate();
22. System.out.println("添加成功!");
23. ps.close();
24. }catch(SQLExceptione)
25. {
26. e.printStackTrace();
27. }
28. }
29. //sql:select*fromstudentwherename=name
30. publicstaticvoidSearch(Connectionconn,Stringsql,Stringname,
Stringscore)
31. {
32. PreparedStatementps;
33. try
34. {
35. ps=conn.prepareStatement(sql);
36. ps.setString(1,name);
评论30