import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import jxl.read.biff.BiffException;
@SuppressWarnings("unused")
public class db {
private Statement stmt=null;
private PreparedStatement psmt=null;
private ResultSet rs=null;
private Connection DB=null;
private final static String DB_DRIVER="oracle.jdbc.driver.OracleDriver";
///连接
public Connection getConnection()
{///"jdbc:oracle:thin:@10.130.90.102:1521:yz"
try{
Class.forName(DB_DRIVER);
// DB=DriverManager.getConnection("jdbc:oracle:thin:@10.130.90.102:1521:yz", "fengf", "fengf");
// DB=DriverManager.getConnection("jdbc:oracle:thin:@10.130.112.87:1521:yz", "ty", "ty83276767");
DB=DriverManager.getConnection("jdbc:oracle:thin:@10.130.90.101:1521:yz", "ty", "ty83276767");
stmt=DB.createStatement();
System.out.println("连接登陆");
}
catch( Exception e)
{
e.printStackTrace();
}
return DB;
}
///断开
public void closeconnection()
{
try{
if(DB!=null)
{
if(!DB.isClosed())
{
DB.close();
}
System.out.println("断开连接");
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
///更新操作、插入操作、删除操作
public boolean UID(String sqlStr,String suansuan,String tablename) throws SQLException
{
if(sqlStr==null||sqlStr.length()==0)
return false;
try{
stmt.executeUpdate(sqlStr);
return true;
}
catch(SQLException e)
{
e.printStackTrace();
System.out.println("error:"+sqlStr);
return false;
}
}
protected int suansuan;
public int SEL(String sqlStr) throws SQLException
{
int rowCount=0;
try{
rs=stmt.executeQuery(sqlStr);
while(rs.next()){
rowCount++;
}
}
catch(SQLException e)
{
// System.out.println(sqlStr);
e.printStackTrace();
}
return rowCount;
}
public void closeStmt()
{
try{
if(stmt!=null)
{
stmt.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void DBset(){
try {
DB.setAutoCommit(false);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void DBCommit()
{
try {
DB.commit();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void DBClose()
{
try {
DB.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public PreparedStatement O(){
try {
psmt=DB.prepareStatement("insert into JSQF_GJ(CITY,CONDATA,CONNO,YFYF,YJZL,JSNY) values(?,?,?,?,?,?)");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return psmt;
}
}