我写的一个bean
package mydb;
import java.sql.*;
public class conn
{
String DBDriver = "org.gjt.mm.mysql.Driver";
String ConnStr = "jdbc:mysql://localhost:3306/net";
Connection conn = null;
public conn() {
try
{
Class.forName(DBDriver);
}
catch (java.lang.ClassNotFoundException error)
{
System.err.println(error.getMessage());
}
} public Connection getconn() {
try
{
conn = DriverManager.getConnection(ConnStr,"","");
return conn;
}
catch (SQLException errorc)
{
System.err.println(errorc.getMessage());
return null;
}
} public void close() {
try {
conn.close();
}
catch (SQLException ex) {
System.err.println(ex.getMessage());
}
}
}
package mydb;
import java.sql.*;
public class conn
{
String DBDriver = "org.gjt.mm.mysql.Driver";
String ConnStr = "jdbc:mysql://localhost:3306/net";
Connection conn = null;
public conn() {
try
{
Class.forName(DBDriver);
}
catch (java.lang.ClassNotFoundException error)
{
System.err.println(error.getMessage());
}
} public Connection getconn() {
try
{
conn = DriverManager.getConnection(ConnStr,"","");
return conn;
}
catch (SQLException errorc)
{
System.err.println(errorc.getMessage());
return null;
}
} public void close() {
try {
conn.close();
}
catch (SQLException ex) {
System.err.println(ex.getMessage());
}
}
}
解决方案 »
- 请教:java导入jmf.jar包的问题!!!急急急!
- 哪位大侠能指导一下小弟用NetBeans连接Sqlsever2005数据库
- Java Swing的用户名和密码如何验证?
- 请问各位高手,用1,2,2,3,4,5这六个书字,用Java写一个main函数,打印出所有的排列,如:512234,412345.要求4不能在第三位,3与5不能
- JSP 问题??
- 用Hibernate做数据更新,如何只更新部分字段?
- 求高手求解一个字符串问题
- 初级问题
- 讨教方案:现有一个上万行的文本文件,每一行又是几个以逗号分隔的数据块,我需要把他读出来,并且根据数据块内容动态的从中筛选数据,谁能提
- 萌新想了很久没想明白
- 一个关于传递参数的问题?
- 为什么IBM的domOne例程不能运行?编译时出现Note: 5 files use or override a deprecated API. Recompile with "-deprecation" for details.错误!
package dbbean;
import java.sql.*;
import java.io.*;
public class dbbean{
String sDBDriver="oracle.jdbc.driver.OracleDriver";
Connection conn=null;
ResultSet rs=null;
//构造函数
public dbbean(){
try{
Class.forName(sDBDriver);
}catch(java.lang.ClassNotFoundException e){
System.err.println("dbbean(): "+e.getMessage());
}
} public ResultSet executeQuery(String sqlStr){
rs=null;
try{
conn=
DriverManager.getConnection"jdbc:oracle:thin:@lmz:1521:labora",
"szfao","szfao");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sqlStr);
}catch(SQLException e){
System.err.println("executeQuery(): "+e.getMessage());
}
return rs;
} public int executeInsert(String sqlStr){
try{
conn=DriverManager.getConnection
("jdbc:oracle:thin:@lmz:1521:labora","szfao","szfao");
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStr);
return 1;//成功
}catch(SQLException e){
System.err.println("executeInsert(): "+e.getMessage());
return 0;//失败
}
} public int executeUpdate(String sqlStr){
try{
conn=DriverManager.getConnection
("jdbc:oracle:thin:@lmz:1521:labora","szfao","szfao");
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStr);
return 1;//成功
}catch(SQLException e){
System.err.println("executeInsert(): "+e.getMessage());
return 0;//失败
}
} public int executeDelete(String sqlStr){
try{
conn=DriverManager.getConnection
("jdbc:oracle:thin:@lmz:1521:labora","szfao","szfao");
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStr);
return 1;//成功
}catch(SQLException e){
System.err.println("executeDelete(): "+e.getMessage());
return 0;//失败
}
}
}