jdbc.java
package wu;
import java.sql.*;
public class jdbc {
public jdbc() {
}
Connection conn = null ;
String re = "" ;
//设置你的数据库ip
String dbip = "127.0.0.1" ;
//设置你的数据库用户名和密码:
String use = "root" ;
String pass = "" ;
public java.sql.Connection getConn(){
try{
//Class.forName("org.gjt.mm.mysql.Driver").newInstance();
//String url ="jdbc:mysql://"+dbip+":3306/lyb"+use+"?user="+use+"&password="+pass+"&useUnicode=true&characterEncoding=gb2312" ;
//conn= DriverManager.getConnection(url);
Class.forName("org.gjt.mm.mysql.Driver");
//String url ="jdbc:mysql://localhost:3306/lyb"
conn= DriverManager.getConnection("jdbc:mysql://localhost/lyb","root","");
}
catch (Exception ex){
}
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 ;
}
}
CREATE database lyb;
CREATE TABLE liuyan_temp (
id int(6) NOT NULL auto_increment,
url varchar(100) default '#',
ip varchar(20) default NULL,
email varchar(50) default '#',
qq varchar(20) default NULL,
sj varchar(30) default NULL,
content text,
xm varchar(20) default '没有姓名',
KEY id (id)
) TYPE=MyISAM;