package firm;
import java.sql.*;public class firm {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:firm";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public firm() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("firm(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
import java.sql.*;public class firm {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:firm";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public firm() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("firm(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
解决方案 »
- ssh中使用了UrlRewrite伪静态之后本来正常的页面就报错了request.geta(),获取不到数据 action,get.set.后的数据也接受不到
- tomcat怎么不能用了?
- javascript onclick 事件 在<a href></a> 中怎么写
- csdn 上的 blog不行了啊?
- jsp新手的问题,我是完全糊涂了
- 一个简单的问题
- 天呀
- 用过smartupload的高手请进,在线等待!
- post和get的问题
- jsp,form表单提交怎么阻止其中一个input数据上传到后台
- 急!我直接从数据库里调数据中文显示网页是正确的,在页面上改过后,就成乱码了?
- 都谁在用DreamweaverMX写JSP?
包括:
config.properites // 属性配置文件(配置数据库所需信息,日志文件路径)
ConfigPath.java // 读取配置文件,保存其配置值
ProcessDB.java // 处理数据库操作(查询,插入,更新,删除)
WriteLog.java // 将数据库操作语句及异常信息写入日志文件有意要否?
[email protected]
import java.sql.*;public class firm {
String sDBDriver = "com.microsoft.jdbc.sqlserver.SqlServerDrive";
String sConnStr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=#";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public firm() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("firm(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
给一份 [email protected]