java代码087

code087.java

1package pack02;
2
3import java.sql.CallableStatement;
4import java.sql.Connection;
5import java.sql.DriverManager;
6import java.sql.ResultSet;
7import java.sql.SQLException;
8import java.util.ArrayList;
9import java.util.List;
10
11public class code087
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	public List<code086> findAll()
37	{
38		List<code086> list1 = new ArrayList<code086>();
39		Connection conn = this.getConnection();
40		try
41		{
42			String procedure = "{call findAllBook()}";
43			CallableStatement statement = conn.prepareCall(procedure);
44			ResultSet rSet = statement.executeQuery();
45			
46			while (rSet.next())
47			{
48				code086 book = new code086();
49				book.setId(rSet.getInt("id"));
50				book.setName(rSet.getString("name"));
51				book.setPrice(rSet.getDouble("price"));
52				book.setBookCount(rSet.getInt("bookCount"));
53				book.setAuthor(rSet.getString("author"));
54				list1.add(book);
55			}
56		} catch (Exception e)
57		{
58			e.printStackTrace();
59		}
60		return list1;
61	}
62}
63