package liuyan;
import java.sql.*;
public class jdbc {
public jdbc() {
}
Connection conn = null ;
String re = "" ;
//设置你的数据库ip
String dbip = "localhost" ;
//设置你的数据库用户名和密码:
String user = "jerry" ;
String pass = "123456" ;
public java.sql.Connection getConn(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url ="jdbc:oracle:thin:@"+dbip+":1521:ORACLE";
conn= DriverManager.getConnection(url,user,pass);
}
catch(Exception e){
e.printStackTrace();
}
return this.conn ;
}
public String ex_chinese(String str){
if(str==null){
str ="" ;
}
else{
try {
str = new String(str.getBytes("iso-8859-1"),"gb2312") ;
}
catch (Exception ex) {
}
}
return str ;
}
public String gettime() {
String datestr = "" ;
try {
java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy年MM月dd日 HH点ss分") ;
java.util.Date date = new java.util.Date() ;
datestr = df.format(new java.util.Date()) ;
}
catch (Exception ex) {
}
return datestr ;
}
}
- 1
- 2
前往页