方法步骤:1,将mysql链接接上
2,TSQL和Student类在kingkit包中
3,新建数据库data1
4,在数据库data1下创建student表,插入几组数据,数据属性分别为 varchar,int,int
1
package
kingkit;
2
3 import java.awt.List;
4 import java.sql.DriverManager;
5 import java.sql.SQLException;
6 import java.util.ArrayList;
7 import com.mysql.jdbc.Connection;
8 import com.mysql.jdbc.PreparedStatement;
9 import com.mysql.jdbc.ResultSet;
10 import com.mysql.jdbc.Statement;
11
12 public class TSQL {
13
14
15
16 public TSQL( ){
17
18 }
19
20 public static void main(String[] args) throws SQLException {
21
22 // 注册驱动
23 try {
24 Class.forName( " com.mysql.jdbc.Driver " );
25 String url = " jdbc:mysql://localhost:3306/data1 " ;
26 String user = " root " ;
27 String password = "" ;
28 /*
29 创建连接
30 */
31 Connection cnn = (Connection) DriverManager.getConnection(url, user, password);
32 /*
33 创建对象执行
34 */
35
36 Student stu = new Student( " quexiaoxia " , 33 , 18 );
37 /*
38 讲学生对象的属性加进数据库中
39 stmt为执行对象
40 */
41
42 ArrayList < Student > list = new ArrayList < Student > ( );
43 PreparedStatement stmt = (PreparedStatement) cnn.prepareStatement( " insert into student values(?,?,?) " );
44 stmt.setString( 1 , stu.getName());
45 stmt.setInt( 2 ,stu.getId());
46 stmt.setInt( 3 ,stu.getAge());
47 stmt.execute();
48
49 /*
50 从数据库中取得数据放进学生对象中
51 学生对象放进ArrayList表中
52 */
53
54 ResultSet rss = (ResultSet) stmt.executeQuery( " select name,id,age from student " );
55 while (rss.next()){
56
57 Student st = new Student( );
58 st.setName(rss.getString( 1 ));
59 st.setId(rss.getInt( 2 ));
60 st.setAge(rss.getInt( 3 ));
61 list.add(st);
62
63 }
64 /*
65 控制台
66 输出数据库信息
67 */
68 for (Student s:list){
69
70 System.out.println(s.getName() + " " + s.getId() + " " + s.getAge());
71
72 }
73
74
75
76 /*
77 关闭数据库操作
78 */
79 stmt.close();
80 cnn.close();
81
82
83 } catch (ClassNotFoundException e) {
84 // TODO Auto-generated catch block
85 e.printStackTrace();
86 }
87 }
88
89 }
90
2
3 import java.awt.List;
4 import java.sql.DriverManager;
5 import java.sql.SQLException;
6 import java.util.ArrayList;
7 import com.mysql.jdbc.Connection;
8 import com.mysql.jdbc.PreparedStatement;
9 import com.mysql.jdbc.ResultSet;
10 import com.mysql.jdbc.Statement;
11
12 public class TSQL {
13
14
15
16 public TSQL( ){
17
18 }
19
20 public static void main(String[] args) throws SQLException {
21
22 // 注册驱动
23 try {
24 Class.forName( " com.mysql.jdbc.Driver " );
25 String url = " jdbc:mysql://localhost:3306/data1 " ;
26 String user = " root " ;
27 String password = "" ;
28 /*
29 创建连接
30 */
31 Connection cnn = (Connection) DriverManager.getConnection(url, user, password);
32 /*
33 创建对象执行
34 */
35
36 Student stu = new Student( " quexiaoxia " , 33 , 18 );
37 /*
38 讲学生对象的属性加进数据库中
39 stmt为执行对象
40 */
41
42 ArrayList < Student > list = new ArrayList < Student > ( );
43 PreparedStatement stmt = (PreparedStatement) cnn.prepareStatement( " insert into student values(?,?,?) " );
44 stmt.setString( 1 , stu.getName());
45 stmt.setInt( 2 ,stu.getId());
46 stmt.setInt( 3 ,stu.getAge());
47 stmt.execute();
48
49 /*
50 从数据库中取得数据放进学生对象中
51 学生对象放进ArrayList表中
52 */
53
54 ResultSet rss = (ResultSet) stmt.executeQuery( " select name,id,age from student " );
55 while (rss.next()){
56
57 Student st = new Student( );
58 st.setName(rss.getString( 1 ));
59 st.setId(rss.getInt( 2 ));
60 st.setAge(rss.getInt( 3 ));
61 list.add(st);
62
63 }
64 /*
65 控制台
66 输出数据库信息
67 */
68 for (Student s:list){
69
70 System.out.println(s.getName() + " " + s.getId() + " " + s.getAge());
71
72 }
73
74
75
76 /*
77 关闭数据库操作
78 */
79 stmt.close();
80 cnn.close();
81
82
83 } catch (ClassNotFoundException e) {
84 // TODO Auto-generated catch block
85 e.printStackTrace();
86 }
87 }
88
89 }
90
1
package
kingkit;
2
3 public class Student {
4
5 private String name;
6 private int id;
7 private int age;
8
9 public Student( ){
10
11 }
12
13 public Student( String name, int id, int age){
14
15 this .name = name;
16 this .id = id;
17 this .age = age;
18
19
20 }
21
22 public String getName() {
23 return name;
24 }
25
26 public void setName(String name) {
27 this .name = name;
28 }
29
30 public int getId() {
31 return id;
32 }
33
34 public void setId( int id) {
35 this .id = id;
36 }
37
38 public int getAge() {
39 return age;
40 }
41
42 public void setAge( int age) {
43 this .age = age;
44 }
45
46 }
47
2
3 public class Student {
4
5 private String name;
6 private int id;
7 private int age;
8
9 public Student( ){
10
11 }
12
13 public Student( String name, int id, int age){
14
15 this .name = name;
16 this .id = id;
17 this .age = age;
18
19
20 }
21
22 public String getName() {
23 return name;
24 }
25
26 public void setName(String name) {
27 this .name = name;
28 }
29
30 public int getId() {
31 return id;
32 }
33
34 public void setId( int id) {
35 this .id = id;
36 }
37
38 public int getAge() {
39 return age;
40 }
41
42 public void setAge( int age) {
43 this .age = age;
44 }
45
46 }
47