- 论坛徽章:
- 0
|
- package com.test.database.control;
- import com.test.database.define.*;
- import java.sql.*;
- //这个程序用来控制expert表,执行expert表的操作
- //状态,完成.
- public class ControlExpert {
- //参数是id,返回的是对象
- public Expert QueryExpert(int id) {
- Expert expert = new Expert();
- try {
- Connection conn = ConnectDatabase.getConnection();
- String sqlQuery = "select * from hos_expert where id=" + id;
- PreparedStatement pstmt = conn.prepareStatement(sqlQuery);
- ResultSet rst = pstmt.executeQuery();
- while (rst.next()) {
- //从数据库中取出数据,然后把数据赋给expert对象
- expert.setName(rst.getString("name"));
- expert.setGrade(rst.getString("grade"));
- expert.setSex(rst.getString("sex"));
- expert.setAge(rst.getInt("age"));
- expert.setContent(rst.getString("content"));
- expert.setPhone(rst.getString("phone"));
- expert.setOffice(rst.getString("office"));
- expert.setEmail(rst.getString("email"));
- expert.setPicLocation(rst.getString("picLocation"));
- pstmt.close();
- conn.close();
- }
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- finally{
- return expert;
- }
- }
复制代码
这个释放资源的方法不太对,但是不影响编译的问题.
finally clause cannot complete normally |
|