81,092
社区成员
发帖
与我相关
我的任务
分享
package rong.web;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Hashtable;
import java.util.Vector;
public class Access_db {
String name = "root";
String password = "root";
String url = "jdbc:mysql://localhost:3306/rtalk";
Connection dbcon = null;
Statement stmt = null;
ResultSet rs = null;
static Access_db ac_db = null;
public Access_db() throws ClassNotFoundException, SQLException {
if (dbcon == null) {
Class.forName("com.mysql.jdbc.Driver");
dbcon = DriverManager.getConnection(url, name, password);
}
}
public static Access_db getInstance() {
try {
ac_db = new Access_db();
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.print("连接出错!");
} catch (SQLException e) {
e.printStackTrace();
System.out.print("连接第二步出错!");
}
return ac_db;
}
//这一次调用是用到下面这个函数的时候报错~
public boolean exeSql(String Sql) {
try {
stmt = dbcon.createStatement();
stmt.executeUpdate(Sql);//单步运行到这的时候,eclipse居然说找不到源;源代码连接不包含文件Connenction.class的源代码;然后叫我点击“更改已连接的源代码”来更改源代码连接
return true;
} catch (SQLException e) {
System.out.print("exeSql error!");
return false;
}
}
public ResultSet Query(String Sql) {
try {
stmt = dbcon.createStatement();
rs = stmt.executeQuery(Sql);
} catch (SQLException e) {
e.printStackTrace();
System.out.print("Query error!");
// System.out.print(Sql);
rs = null;
}
return rs;
}
public Vector QueryVet(String Sql) {
Vector vet = null;
try {
stmt = dbcon.createStatement();
rs = stmt.executeQuery(Sql);//以前调用这个函数的时候会
ResultSetMetaData meta = rs.getMetaData();
while (rs.next()) {
Hashtable hash = new Hashtable();
for (int i = 0; i < meta.getColumnCount(); i++) {
hash.put(meta.getColumnName(i + 1).toLowerCase(), rs
.getString(i + 1) == null ? "" : rs
.getString(i + 1));
}
vet.add(hash);
}
} catch (Exception e) {
System.out.print("VET异常!");
}
return vet;
}
}
public class Cwords {
String Sql = "";
String WordsTitle = "";
String WordsContent = "";
String WordsTime;
int ID = 0;
int UserID = 0;
Access_db ac;
SimpleDateFormat TimeFormat;
//下面就是设置时间格式,是不是这里设置错了
public Cwords() {
TimeFormat = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss");
WordsTime = TimeFormat.format(new java.util.Date());
ac = Access_db.getInstance();
}
public boolean add_words() {
Sql = "insert into words(WordsTitle,WordsContent,WordsTime,UserID)values('"
+ WordsTitle
+ "','"
+ WordsContent
+ "','"
+ WordsTime
+ "','"
+ UserID + "')";
System.out.print(Sql);
boolean is_add = ac.exeSql(Sql);
return is_add;
}}