?? gbookmanger.java
字號:
package cn.jack.bean;
import cn.jack.form.GbookForm;
import cn.jack.tool.*;
import java.sql.*;
import java.util.*;
public class GbookManger {
DBConnection DBConn = new DBConnection();
public void Save(String gbtitle,String gbuser,String gbmail,String gbcontent,String gbface,String gbtime,String gbip){
Connection Conn = DBConn.getConn();
PreparedStatement ps = null;
StringBuffer sb = new StringBuffer();
sb.append("insert into BookContent");
sb.append("(gbtitle,gbuser,gbmail,gbcontent,gbface,gbtime,gbip)");
sb.append("values(?,?,?,?,?,?,?)");
try
{
ps = Conn.prepareStatement(sb.toString());
ps.setString(1,gbtitle);
ps.setString(2,gbuser);
ps.setString(3,gbmail);
ps.setString(4, gbcontent);
ps.setString(5,gbface);
ps.setString(6, gbtime);
ps.setString(7, gbip);
ps.executeUpdate();
ps.close();
Conn.close();
}catch(Exception e){}
}
public List itemlist(){
List ax = new ArrayList();
Connection Conn = DBConn.getConn();
Statement stmt = null;
ResultSet rs = null;
String sql="select * from BookContent order by id desc";
try
{
stmt = Conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
GbookForm gf = new GbookForm();
gf.setGbcontent(StringTool.ConversionAll(rs.getString("gbcontent")));
gf.setGbface(rs.getString("gbface"));
gf.setGbip(rs.getString("gbip"));
gf.setGbtime(rs.getString("gbtime"));
gf.setGbtitle(rs.getString("gbtitle"));
gf.setGbuser(rs.getString("gbuser"));
gf.setId(rs.getInt("id"));
gf.setGbre(rs.getString("gbre"));
gf.setGbretime(rs.getString("gbretime"));
ax.add(gf);
}
rs.close();
stmt.close();
Conn.close();
}catch(Exception e){}
return ax;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -