mysql的db.properties,经过properties配置文件连接数据库

当前位置:我的异常网» 数据库 » 经过properties配置文件连接数据库

经过properties配置文件连接数据库

www.myexceptions.net  网友分享于：2013-11-20  浏览：4次

通过properties配置文件连接数据库

**

* @作者：Jcuckoo

* @日期：2008-11-8

* @版本：V 1.0

*/

db.properties

DBDriver=sun.jdbc.odbc.JdbcOdbcDriver

Connection=jdbc:odbc:login

User=Jcuckoo

Password=

dbPool.java

import java.io.*;

import java.util.*;

import java.sql.*;

public class dbPool{

private static dbPool instance = null;

//取得连接

public static synchronized Connection getConnection() {

if (instance == null){

instance = new dbPool();

}

return instance._getConnection();

}

private dbPool(){

super();

}

private  Connection _getConnection(){

try{

String sDBDriver  = null;

String sConnection   = null;

String sUser = null;

String sPassword = null;

Properties p = new Properties();

InputStream is = getClass().getResourceAsStream("/db.properties");

p.load(is);

sDBDriver = p.getProperty("DBDriver",sDBDriver);

sConnection = p.getProperty("Connection",sConnection);

sUser = p.getProperty("User","");

sPassword = p.getProperty("Password","");

Properties pr = new Properties();

pr.put("user",sUser);

pr.put("password",sPassword);

pr.put("characterEncoding", "GB2312");

pr.put("useUnicode", "TRUE");

Class.forName(sDBDriver).newInstance();

return DriverManager.getConnection(sConnection,pr);

}

catch(Exception se){

System.out.println(se);

return null;

}

}

//释放资源

public static void dbClose(Connection conn,PreparedStatement ps,ResultSet rs)

throws SQLException

{

rs.close();

ps.close();

conn.close();

}

}

StudentDAO.java

public class StudentDAO {

public StudentDAO() {

}

Connection conn;

Statement st;

ResultSet rs;

public boolean checkLogin(String userName,String userPwd){

String sql="select * from student where userName='"+userName+"' and userPwd='"+userPwd+"'";

try {

conn=dbPool.getConnection();

st=conn.createStatement();

rs=st.executeQuery(sql);

if(rs.next()){

conn.close();

return true;

}else{

conn.close();

return false;

}

} catch (SQLException e) {

try {

conn.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

e.printStackTrace();

return false;

}

}

public boolean checkLogin(StudentForm student){

String sql="select * from student where userName='"+student.getUserName()+"' and userPwd='"+student.getUserPwd()+"'";

try {

conn=dbPool.getConnection();

st=conn.createStatement();

rs=st.executeQuery(sql);

if(rs.next()){

conn.close();

return true;

}else{

conn.close();

return false;

}

} catch (SQLException e) {

try {

conn.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

e.printStackTrace();

return false;

}

}

public List getAllStudent(){

String sql="select * from student ";

List students=new ArrayList();

try {

conn=dbPool.getConnection();

st=conn.createStatement();

rs=st.executeQuery(sql);

while(rs.next()){

Student student=new Student(rs.getString("xuehao"),

rs.getString("userName"),

rs.getString("userPwd"),

rs.getInt("czxt"),

rs.getInt("wjyl"),

rs.getInt("sjjg")

);

students.add(student);

}

} catch (SQLException e) {

try {

conn.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

e.printStackTrace();

return null;

}

return students;

}

public Student getStudentByXuehao(String xuehao){

String sql="select * from student where xuehao='"+xuehao+"'";

Student student=null;

try {

conn=dbPool.getConnection();

st=conn.createStatement();

rs=st.executeQuery(sql);

if(rs.next()){

student=new Student(rs.getString("xuehao"),

rs.getString("userName"),

rs.getString("userPwd"),

rs.getInt("czxt"),

rs.getInt("wjyl"),

rs.getInt("sjjg")

);

}

return student;

} catch (SQLException e) {

try {

conn.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

e.printStackTrace();

return null;

}

}

public boolean deleteStudent(String xuehao){

String sql="delete from student where xuehao='"+xuehao+"'";

conn=dbPool.getConnection();

try {

st=conn.createStatement();

st.execute(sql);

conn.close();

return true;

} catch (SQLException e) {

e.printStackTrace();

try {

conn.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

return false;

}

}

public boolean updateStudent(Student student){

String sql="update student set userName='" +student.getUserName()+

"',userPwd='" +student.getUserPwd()+"',czxt="+student.getCzxt()+

",wjyl="+student.getWjyl()+",sjjg="+student.getSjjg()+" where xuehao='"+student.getXuehao()+"'";

conn=dbPool.getConnection();

try {

st=conn.createStatement();

st.execute(sql);

conn.close();

return true;

} catch (SQLException e) {

e.printStackTrace();

try {

conn.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

return false;

}

}

public boolean insertStudent(Student student){

String sql="insert into student values('"+student.getXuehao()+"','" +student.getUserName()+

"','" +student.getUserPwd()+"',"+student.getCzxt()+

","+student.getWjyl()+","+student.getSjjg()+")";

//System.out.println(sql);

conn=dbPool.getConnection();

try {

st=conn.createStatement();

st.execute(sql);

conn.close();

return true;

} catch (SQLException e) {

e.printStackTrace();

try {

conn.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

return false;

}

}

}

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/guoquanyou/archive/2008/12/01/3418933.aspx

文章评论