jsp_servlet(4)-CSDN博客

author="Evangelion"

jdbc.java做的是bean 在jsp中使用

package com.tom.javaBean;

import java.sql.*;

public class JDBC {

private Connection con;
private PreparedStatement pre;
public ResultSet rs;
private String inputName;
private String selectTime;
private String vacationText;
private String selectDays;

static {
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver"); // 加载驱动
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
}

public void getConnection() {
  String url = "jdbc:oracle:thin:@10.19.115.131:1521:orcl";
  String username = "raop";
  String password = "raop12345";
  try {
   con = DriverManager.getConnection(url, username, password); // 连接数据库
  } catch (SQLException e) {
   e.printStackTrace();
  }
}

public ResultSet doQuery(String text1) { // 做查询
  this.getConnection(); // 先连接
  try {
   pre = con.prepareStatement("select * from tomigjun_vacation where user_name=?");
   pre.setString(1, text1);
   rs = pre.executeQuery();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return rs;
}

public int doUpdate(String text1,String text2,String text3,String text4) {//提交insert
this.getConnection();
int count = 0;

  try {

   pre = con.prepareStatement("insert into tomigjun_vacation values (?,?,?,?)");
   pre.setString(1, text1);
   pre.setString(2, text2);
   pre.setString(3, text3);
   pre.setString(4, text4);
   count = pre.executeUpdate();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return count;
}
// public int doUpdate(DbOperator dba) {//提交insert
//  this.getConnection();
//  int count = 0;
//
//  try {
//   pre = con.prepareStatement("insert into pclink values (?,?,?)");
//   pre.setInt(1, 1);
//   pre.setInt(2, 0);
//   pre.setString(3, dba.getVacationText());
//
//   count = pre.executeUpdate();
//  } catch (SQLException e) {
//   e.printStackTrace();
//  }
//  return count;
// }

// public int doUpdate(String sql, Object[] args) {//提交多个insert语句
//  this.getConnection();
//  int count = 0;
//  try {
//   pre = con.prepareStatement(sql);
//   for (int i = 0; i < args.length; i++) {
//    pre.setObject(i + 1, args[i]);
//   }
//   count = pre.executeUpdate();
//  } catch (SQLException e) {
//   e.printStackTrace();
//  }
//  return count;
// }

public void closeQuery() {
  try {
   rs.close();
   pre.close();
   con.close();
  } catch (SQLException e) {
   e.printStackTrace();
  }
}

public void closeUpdate() {
  try {
   pre.close();
   con.close();
  } catch (SQLException e) {
   e.printStackTrace();
  }
}
public String getSelectDays()
{
  return this.selectDays;
}
public void setSelectDays(String selectDays)
{
  this.selectDays=selectDays;
}

public void setInputName(String inputName)
{
  this.inputName=inputName;
}
public void setSelectTime(String selectTime)
{
  this.selectTime=selectTime;
}
public void setVacationText(String vacationText)
{
  this.vacationText=vacationText;
}

public String getSelectTime()
{
return this.selectTime;
}
public String getVacationText()
{
return this.vacationText;
}

public String getInputName()
{
return inputName;
}

public void qall(String text1)
{
doQuery(text1);
}

public void insertInfo(String text1,String text2,String text3,String text4)
{
doUpdate(text1,text2,text3,text4);
}

}

转载于:https://www.cnblogs.com/tom38/p/3414204.html