1 import java.sql.Connection;
2 import java.sql.DriverManager;
3 import java.sql.ResultSet;
4 import java.sql.SQLException;
5 import java.sql.Statement;
6 //虽然是使用的JDBC 但这在里引用的都是sql下的。
7 public class JDBC {
8
9 public static void main(String[] args) {
10 Statement stat = null ;
11 Connection conn=null;
12 ResultSet resultSet= null;
13
14 //1.加载JDBC驱动
15 try {
16 Class.forName("com.mysql.jdbc.Driver");
17 } catch (ClassNotFoundException e) {
18 // TODO Auto-generated catch block
19 e.printStackTrace();
20 }
21 //2、建立数据库连接
22
23 try {
24 conn= DriverManager.getConnection("jdbc:mysql://localhost:3308/shxt","root","mysql");
25 } catch (SQLException e) {
26 // TODO Auto-generated catch block
27 e.printStackTrace();
28 }
29
30
31 //3、用数据库连接生成语句对象
32 try {
33 stat= conn.createStatement();
34 } catch (SQLException e) {
35 // TODO Auto-generated catch block
36 e.printStackTrace();
37 }
38 //4、用语句对象执行sql
39 String sqlInsert = "insert into student(sid,sname,age)values(32,'小龙龙',22)";
40 String sqlSelect ="select sid,sname,age from student";
41 int a=0;
42
43 try {
44 resultSet= stat.executeQuery(sqlSelect);
45
46 } catch (SQLException e1) {
47 // TODO Auto-generated catch block
48 e1.printStackTrace();
49 }
50 /*try {
51 int a =stat.executeUpdate(sqlInsert);
52 if(a >0){
53 System.out.println("修改成功!");
54 }else {
55 System.out.println("修改失败!");
56 }
57 } catch (SQLException e) {
58 // TODO Auto-generated catch block
59 e.printStackTrace();
60 }
61 */
62 try {
63 while(resultSet.next())
64 {
65 String sid = resultSet.getString("sid");
66 String sname = resultSet.getString("sname");
67 String age = resultSet.getString("age");
68 System.out.println(sid+" "+sname+" "+age);
69 }
70 } catch (SQLException e1) {
71 // TODO Auto-generated catch block
72 e1.printStackTrace();
73 }
74 //5、释放资源(数据库连接)
75 try {
76 conn.close();
77 } catch (SQLException e) {
78 // TODO Auto-generated catch block
79 e.printStackTrace();
80 }
81
82 }
83 }