package fourm.conndb;
import java.sql.*
public class opendb {
String dbDriver = "org.gjt.mm.mysql.Driver"; //驱动名
String dbUrl = "jdbc:mysql://localhost:3306/jspuser"; //数据URL地址
Connection Conn;//数据库连接
//Statement Stmt;
ResultSet Rs; //数据记录集
String Username="root"; //数据库用户名
String Password=""; //数据库密码
public opendb(){
try{
Class.forName(dbDriver);
}
catch(java.lang.ClassNotFoundException e){
System.out.println(e.getMessage() ) ;
}
}
public ResultSet executeQuery(String sql){
Rs=null;
try{
Conn=DriverManager.getConnection(dbUrl,Username,Password);
Statement Stmt=Conn.createStatement() ;
Rs=Stmt.executeQuery(sql);
}
catch(SQLException e){
System.out.println(e.getMessage() ) ;
}
}
public void executeUpdate(String sql){
try{
Conn=DriverManager.getConnection(dbUrl,Username,Password);
Statement Stmt=Conn.createStatement() ;
Stmt.executeUpdate(sql) ;
}
catch(SQLException e){
System.out.println(e.getMessage() );
}
}
}
一定行的,给点分吧
import java.sql.*
public class opendb {
String dbDriver = "org.gjt.mm.mysql.Driver"; //驱动名
String dbUrl = "jdbc:mysql://localhost:3306/jspuser"; //数据URL地址
Connection Conn;//数据库连接
//Statement Stmt;
ResultSet Rs; //数据记录集
String Username="root"; //数据库用户名
String Password=""; //数据库密码
public opendb(){
try{
Class.forName(dbDriver);
}
catch(java.lang.ClassNotFoundException e){
System.out.println(e.getMessage() ) ;
}
}
public ResultSet executeQuery(String sql){
Rs=null;
try{
Conn=DriverManager.getConnection(dbUrl,Username,Password);
Statement Stmt=Conn.createStatement() ;
Rs=Stmt.executeQuery(sql);
}
catch(SQLException e){
System.out.println(e.getMessage() ) ;
}
}
public void executeUpdate(String sql){
try{
Conn=DriverManager.getConnection(dbUrl,Username,Password);
Statement Stmt=Conn.createStatement() ;
Stmt.executeUpdate(sql) ;
}
catch(SQLException e){
System.out.println(e.getMessage() );
}
}
}
一定行的,给点分吧
不好意思
但我不想用ODBC
能给个连MSSQL的例子吗??
public class opendb {
String dbDriver = "org.gjt.mm.mysql.Driver"; //驱动名
String dbUrl = "jdbc:mysql://localhost:3306/jspuser"; //数据URL地址
Connection Conn;//数据库连接
//Statement Stmt;
ResultSet Rs; //数据记录集
String Username="root"; //数据库用户名
String Password=""; //数据库密码
public opendb(){
try{
Class.forName(dbDriver);
}
catch(java.lang.ClassNotFoundException e){
System.out.println(e.getMessage() ) ;
}
}
public ResultSet executeQuery(String sql){
Rs=null;
try{
Conn=DriverManager.getConnection(dbUrl,Username,Password);
Statement Stmt=Conn.createStatement() ;
Rs=Stmt.executeQuery(sql);
}
catch(SQLException e){
System.out.println(e.getMessage() ) ;
}
}
public void executeUpdate(String sql){
try{
Conn=DriverManager.getConnection(dbUrl,Username,Password);
Statement Stmt=Conn.createStatement() ;
Stmt.executeUpdate(sql) ;
}
catch(SQLException e){
System.out.println(e.getMessage() );
}
}
}
lgcfm(我爱凌雪)已经告诉你了...