java 内容存储库_数据库的封装，并利用javabean来存储取得内容

package com.zhao.practice726;

/**

* javaBean

* @author Administrator

*

*/

public class Person {

private int id;

private String name;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

@Override

public String toString() {

return id+"  "+name;

}

}

package com.zhao.practice726;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

public class TestDBHelper {

private static List list = null;

/**

* @param args

*/

public static void main(String[] args) {

String sql = "select id ,name from test1";

TestDBHelper test = new TestDBHelper();

list = test.meth0d2(sql);

//for增强

for(Person person : list){

System.out.println(person.getName());

}

}

/**

* 利用集合来封装

*/

private List meth0d2(String sql){

list = new ArrayList();

Person person = null;

DBHelper db = new DBHelper();

ResultSet rs = db.getDataByQuery(sql);

try{

while(rs.next()){

person = new Person();

person.setId(rs.getInt("id"));

person.setName(rs.getString("name"));

list.add(person);

}

return list;

}catch(SQLException e){

e.printStackTrace();

}

return null;

}

/**

* 简单测试

*/

private void method1(String sql) {

DBHelper db = new DBHelper();

ResultSet rs = db.getDataByQuery(sql);

try {

while (rs.next()) {

System.out.println(rs.getString(1) + "  " + rs.getString(2));

}

} catch (SQLException e) {

e.printStackTrace();

}

db.close();

}

}

package com.zhao.practice726;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class DBHelper {

/**

* 加载类字符串

*/

private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

/**

* url字符串

*/

private static final String URL = "jdbc:sqlserver://localhost:1433; DatabaseName=zhao722";

/**

* 用户名字符串

*/

private static final String USER = "sa";

/**

* 登陆密码字符串

*/

private static final String PASSWORD = "zhao";

/**

* 连接数据库

*/

Connection conn = null;

/**

* 获取Statement

*/

Statement stat = null;

/**

* 获取结果集

*/

ResultSet rs = null;

static {

try {

Class.forName(DRIVER);

} catch (Exception e) {

e.printStackTrace();

}

}

/**

* 获取数据库连接

*/

private Connection getConnection() {

try {

conn = DriverManager.getConnection(URL, USER, PASSWORD);

return conn;

} catch (SQLException e) {

e.printStackTrace();

}

return null;

}

/**

* 获得Statement

*/

private Statement getStatement() {

try {

stat = getConnection().createStatement();

return stat;

} catch (SQLException e) {

e.printStackTrace();

}

return null;

}

/**

* 获取ResultSet

*

* @param sql

*            sql语句

* @return 查询到的ResultSet

*/

public ResultSet getDataByQuery(String sql) {

try {

rs = getStatement().executeQuery(sql);

return rs;

} catch (SQLException e) {

e.printStackTrace();

}

return null;

}

/**

* 对数据库进行增删改查

*

* @param sql

*            sql语句

* @return int

*/

public int operatorLineByQuery(String sql) {

try {

int line = getStatement().executeUpdate(sql);

return line;

} catch (SQLException e) {

e.printStackTrace();

}

return 0;

}

/**

* 关闭所有在数据库上的连接

*/

public void close() {

try {

if (rs != null){

rs.close();

}

if(stat != null){

stat.close();

}

if(conn != null){

conn.close();

}

} catch (SQLException e) {

e.printStackTrace();

}

}

}