com包

最新推荐文章于 2021-02-24 14:28:52 发布

mlzyk001

最新推荐文章于 2021-02-24 14:28:52 发布

阅读量674

点赞数

文章标签： sqlserver microsoft string jdbc sql class

本文链接：https://blog.csdn.net/mlzyk001/article/details/6482408

版权

package com;
import java.sql.*;
public class DBConnection {
Connection con;
public DBConnection(){
  String url="jdbc:oracle:thin:@localhost:1521:mis";
// String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=book";
  String user="scott";
  String password="tiger";

  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
//  Class.forName("com.mircosoft.jdbc.sqlserver.SQLServerDriver");
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
  try {
   con=DriverManager.getConnection(url,user,password);
  } catch (SQLException e) {
   e.printStackTrace();
  }
}
public Connection getConnection(){
  return con;
}
}

///

package com;

import java.util.ArrayList;

import java.sql.*;

import actionform.bookform;

public class bookdao {

public ArrayList getSelect(String sql){
  ArrayList list= new ArrayList();
  DBConnection db=new DBConnection();
  Connection con=db.getConnection();
  try {
   Statement stm= con.createStatement();
   ResultSet rs=stm.executeQuery(sql);

   while(rs!=null&&rs.next()){
    bookform b=new bookform();
    b.setId(rs.getString("id"));
    b.setAuthor(rs.getString("author"));
    b.setTitle(rs.getString("title"));
    b.setPublish(rs.getString("publish"));
    b.setTime(rs.getString("time"));
    b.setPrice(rs.getString("price"));
    list.add(b);
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return list;
}
public int getadd(String sql){

  DBConnection DB= new DBConnection();
  Connection con =DB.getConnection();
   int i=0;
  Statement stm;
  try {
   stm = con.createStatement();
   i=stm.executeUpdate(sql);
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return i;
}

}