conndb.java

我参加SUN JAVA 初级比赛的答卷 一个注册模块

package org.dyq.math.connDB;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnDB {
	private String diver="org.gjt.mm.mysql.Driver";
	private String url="jdbc:mysql://localhost:3306/math";
	private String name="root";
	private String pwd="fdx123";
	private Connection conn;
	private Statement stmt;
	private ResultSet rs;
	//public boolean isConn;
	public boolean createConn(){
		boolean isConn=false;
		try {
			Class.forName(diver).newInstance();
			conn=DriverManager.getConnection(url,name,pwd);
			stmt=conn.createStatement();
			isConn=true;			
		} catch (InstantiationException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return isConn;
	}
	public void closeConn(){
		try {
			if(rs!=null)rs.close();
			if(stmt!=null)stmt.close();
			if(conn!=null)conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void query(String sql){
		try {
			rs=stmt.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public boolean next(){
		boolean b=false;
		if(rs!=null){
		try {
			if(rs.next())b=true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		}
		return b;
	}
	public boolean update(String sql){
		boolean b=false;
		//stmt=conn.createStatement();
		try {
			stmt.execute(sql);
			b=true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return b;
	}
	

}