java代码084

code084.java

1package pack02;
2
3import java.sql.Connection;
4import java.sql.DriverManager;
5import java.sql.PreparedStatement;
6import java.sql.SQLException;
7import java.util.Random;
8
9public class code084
10{
11
12		
13	public Connection getConnection()
14	{
15		Connection conn = null;
16		try
17		{
18			Class.forName("com.mysql.jdbc.Driver");
19			String url = "jdbc:mysql://localhost:3306/test";
20			String user = "root";
21			String pwd = "mysql123";
22			conn = DriverManager.getConnection(url,user,pwd);
23			
24		} 
25		catch (ClassNotFoundException e)
26		{
27			e.printStackTrace();
28		}
29		catch (SQLException e) 
30		{
31			e.printStackTrace();
32		}
33		return conn;
34	}
35	
36	/**
37	 * 
38	 * @return �����˼�������
39	 */
40	public int saveBatch()
41	{
42		
43		int row = 0;
44		Connection conn = this.getConnection();
45		try
46		{
47			String sql = "insert into tb_student_batch(name,sex,age) values(?,?,?)";
48			PreparedStatement stmt = conn.prepareStatement(sql);
49			
50			Random rand1 = new Random(); 
51			for (int i = 0; i < 10; i++)
52			{
53				stmt.setString(1, "ѧ��" + (i+1));
54				stmt.setBoolean(2, i % 2 == 0 ? true:false);
55				stmt.setInt(3, rand1.nextInt(5) + 10);
56				stmt.addBatch(); //��������
57			}
58			int rows[] = stmt.executeBatch();
59			row = rows.length;
60			stmt.close();
61			conn.close();
62		} catch (Exception e)
63		{
64			e.printStackTrace();
65		}
66		return row;
67	}
68}
69