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

最新推荐文章于 2021-02-18 00:56:06 发布

D_SJ

最新推荐文章于 2021-02-18 00:56:06 发布

阅读量236

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/u/586106/blog/69197

版权

2019独角兽企业重金招聘Python工程师标准>>>

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<Person> 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<Person> meth0d2(String sql){
  list = new ArrayList<Person>();
  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();
  }