//db.javapackagecom;importjava.sql.*;importjava.util.*;importjava.io.*;publicclassdb{Stringurl="jdbc:mysql://localhost/jsp?useUnicode=true&characterEncoding=gb2312";Strin...
//db.java
package com;
import java.sql.*;
import java.util.*;
import java.io.*;
public class db{
String url = "jdbc:mysql://localhost/jsp?useUnicode=true&characterEncoding=gb2312";
String userName = "root";
String password = "123456";
Connection conn = null;
Statement stmt;
ResultSet rs;
/**
*@初始化操作,包括给变量赋初值和连接数据库
*/
public db(){
//连接数据库
stmt = null;
rs = null;
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException ex) {
System.out.println("加载驱动器类时出现异常");
}
try{
conn = DriverManager.getConnection(url, userName, password);
}catch(SQLException ex) {
System.out.println("出现SQLException异常");
}
if(conn != null){
System.out.println("连接成功");
}
}
/**
*@对数据库执行sql执行语句,主要是插入和更新操作,返回一个布尔值变量
*/
public boolean exeSql(String strSql){
try{
stmt=conn.createStatement();
stmt.executeUpdate(strSql);
return true;
}catch(Exception ex){
//打印出异常信息
System.out.println(ex.toString());
return false;
}
}
/**
*@对数据库执行sql查询语句,返回一个ResultSet类型的对象
*/
public ResultSet exeSqlQuery(String strSql){
try{
stmt=conn.createStatement();
rs =stmt.executeQuery(strSql);
}catch(Exception ex){
//打印出异常信息
System.out.println(ex.toString());
rs = null;
}
return rs;
}
}
连接失败,大虾帮忙看一下
展开