package steven;
import java.io.*;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;
public class dataop {
private String className; //撽勗���
private String url;
private String username; //��摨�����
private String password; //��摨����
private Connection con; //��摨�撖寡情
private PreparedStatement pstm; //��摨�����笆鞊�
private Statement stmt;
private ResultSet rs;
private String sqlstr;
private int result1;
public dataop(){
className="com.microsoft.sqlserver.jdbc.SQLServerDriver";
url="";
username="sa";
password="monfongs@2018";
try{
Class.forName(className);
}catch(ClassNotFoundException e){
System.out.println("��蝸��摨店�蝔�仃韐伐��");
e.printStackTrace();
}
}
public void getCon(){
try {
con=DriverManager.getConnection("jdbc:sqlserver://10.30.1.122:1433;DatabaseName=MonFongsOA","sa","monfongs@2018");;
stmt = con.createStatement();
} catch (SQLException e) {
System.out.println("����摨�憭梯揖嚗�");
e.printStackTrace();
}
}
public int sUpdate(String sqlstr) throws SQLException{
result1 = stmt.executeUpdate(sqlstr);
return result1 ;
}
public ResultSet getRs(String sqlstr){
try { rs = stmt.executeQuery(sqlstr);
return rs;
} catch (SQLException e) {
System.out.println("DB蝐颱葉��etRs()�瘜����");
e.printStackTrace();
return null;
}
}
public void closed(){
try{
if(pstm!=null)
pstm.close();
}catch(Exception e){
System.out.println("��pstm撖寡情憭梯揖嚗�");
}
try{
if(con!=null)
con.close();
}catch(Exception e){
System.out.println("��con撖寡情憭梯揖嚗�");
}
}
}