📄 cardcom.java
字号:
card.setUserName(rs.getString("UserName"));
card.setTitle(rs.getString("Title"));
card.setKyeword(rs.getString("Keyword"));
card.setContent(rs.getString("Content"));
card.setPassOrNot(rs.getBoolean("PassOrNot"));
card.setCName(rs.getString("CName"));
card.setCount(rs.getInt("Counnt"));
card.setCPath(rs.getString("CPath"));
card.setTitleDetail(rs.getString("TitleDetail"));
card.setTuiJian(rs.getString("TuiJian"));
card.setDate(rs.getString("Date"));
card.setZuozhe(rs.getString("zuozhe"));
card.setSouce(rs.getString("Souce"));
vc.add(card);
}
return vc;
}
catch(SQLException e){return null;}
}
public Vector getAllSerchCard(String CPath ,String Keyword,String order_condition)
{
Vector vc = new Vector();
String sql;
String sort;
if(order_condition.equals("byTime"))
sort = new String("Date");
else
sort = new String("Counnt");
if(CPath.equals("all")){
if(Keyword.equals("all"))
sql = "select * from cardinf where PassOrNot=true order by " + sort +" desc";
else
//sql = "select * from cardinf where PassOrNot=true and ( Keyword=" + Keyword + ") order by "+sort+ " desc";
sql = "select * from cardinf where PassOrNot=true and (Title like '%" +Keyword+"%' or Keyword like '%" + Keyword + "%') order by "+sort+ " desc";
}
else
{
if(Keyword.equals("all"))
sql = "select * from cardinf where PassOrNot=true and CPath LIKE '" + CPath +"%' order by " + sort +" desc";
else
//sql = "select * from cardinf where PassOrNot=true and CPath LIKE '" + CPath +"%' and ( Keyword=" + Keyword + ") order by " + sort + " desc";
sql = "select * from cardinf where PassOrNot=true and CPath LIKE '" + CPath +"%' and (Title like '%" +Keyword+"%' or Keyword like '%" + Keyword + "%') order by " + sort + " desc";
}
try
{
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
Card card = new Card(rs.getInt("CardID"));
card.setFileName(rs.getString("image"));
card.setUserName(rs.getString("UserName"));
card.setTitle(rs.getString("Title"));
card.setKyeword(rs.getString("Keyword"));
card.setContent(rs.getString("Content"));
card.setPassOrNot(rs.getBoolean("PassOrNot"));
card.setCName(rs.getString("CName"));
card.setCount(rs.getInt("Counnt"));
card.setCPath(rs.getString("CPath"));
card.setTitleDetail(rs.getString("TitleDetail"));
card.setTuiJian(rs.getString("TuiJian"));
card.setDate(rs.getString("Date"));
card.setZuozhe(rs.getString("zuozhe"));
card.setSouce(rs.getString("Souce"));
vc.add(card);
}
return vc;
}
catch(SQLException e){return null;}
}
public int getCountSerchCard(String CPath ,String Keyword,String order_condition)
{
//Vector vc = new Vector();
int count = 0;
String sql;
//String sort;
//if(order_condition.equals("byTime"))
//sort = new String("Date");
//else
//sort = new String("Counnt");
if(CPath.equals("all")){
if(Keyword.equals("all"))
sql = "select count(*) from cardinf where PassOrNot=true";
else
sql = "select count(*) from cardinf where PassOrNot=true and (Title like '%" +Keyword+"%' or Keyword like '%" + Keyword + "%')";
}
else
{
if(Keyword.equals("all"))
sql = "select count(*) from cardinf where PassOrNot=true and CPath LIKE '" + CPath +"%'";
else
sql = "select count(*) from cardinf where PassOrNot=true and CPath LIKE '" + CPath +"%' and (Title like '%" +Keyword+"%' or Keyword like '%" + Keyword + "%')";
}
try
{
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
count = rs.getInt(1);
}
return count;
}
catch(SQLException e){return 0;}
}
public Vector getCardByUserName(String username,int pagenum,String order_condition)
{
int begin = 0;
begin = (pagenum-1)*8;
PreparedStatement pre;
Vector vc = new Vector();
String sort;
if(order_condition.equals("byTime"))
sort = new String("Date");
else
sort = new String("Counnt");
String sql = "select * from cardinf where UserName = ? and PassOrNot = ? order by "+sort+" desc limit " +begin +",8";
try
{
pre = con.prepareStatement(sql);
pre.setString(1, username);
pre.setBoolean(2, true);
ResultSet rs = pre.executeQuery();
while(rs.next())
{
Card card = new Card(rs.getInt("CardID"));
card.setFileName(rs.getString("image"));
card.setUserName(rs.getString("UserName"));
card.setTitle(rs.getString("Title"));
card.setKyeword(rs.getString("Keyword"));
card.setContent(rs.getString("Content"));
card.setPassOrNot(rs.getBoolean("PassOrNot"));
card.setCName(rs.getString("CName"));
card.setCount(rs.getInt("Counnt"));
card.setCPath(rs.getString("CPath"));
card.setTitleDetail(rs.getString("TitleDetail"));
card.setTuiJian(rs.getString("TuiJian"));
card.setDate(rs.getString("Date"));
card.setZuozhe(rs.getString("zuozhe"));
card.setSouce(rs.getString("Souce"));
vc.add(card);
}
return vc;
}
catch(SQLException e){return null;}
}
/**
* 根据从属类别名 查找出该类别中所有通过审核的Card
* @param CName 类别名
* @return
*/
public Vector getAllCard(String CPath,String order_condition)
{
PreparedStatement pre;
String sort;
if(order_condition.equals("byTime"))
sort = new String("Date");
else
sort = new String("Counnt");
String sql = "select * from cardinf where CPath LIKE '" + CPath +"%' and PassOrNot = ? order by " +sort+" desc";
Vector vc = new Vector();
try
{
pre = con.prepareStatement(sql);
//pre.setString(1, CName);
pre.setBoolean(1, true);
ResultSet rs = pre.executeQuery();
while(rs.next())
{
Card card = new Card(rs.getInt("CardID"));
card.setFileName(rs.getString("image"));
card.setUserName(rs.getString("UserName"));
card.setTitle(rs.getString("Title"));
card.setKyeword(rs.getString("Keyword"));
card.setContent(rs.getString("Content"));
card.setPassOrNot(rs.getBoolean("PassOrNot"));
card.setCName(rs.getString("CName"));
card.setCount(rs.getInt("Counnt"));
card.setCPath(rs.getString("CPath"));
card.setTitleDetail(rs.getString("TitleDetail"));
card.setTuiJian(rs.getString("TuiJian"));
card.setDate(rs.getString("Date"));
card.setZuozhe(rs.getString("zuozhe"));
card.setSouce(rs.getString("Souce"));
vc.add(card);
}
return vc;
}
catch(SQLException e){return null;}
}
public Vector getAllCard(int pagenum,String order_condition)
{
int begin = 0;
begin = (pagenum-1)*8;
String sort;
if(order_condition.equals("byTime"))
sort = new String("Date");
else
sort = new String("Counnt");
String sql = "select * from cardinf where PassOrNot=true order by "+sort+" desc limit "+begin+",8";
Vector vc = new Vector();
try
{
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
Card card = new Card(rs.getInt("CardID"));
card.setFileName(rs.getString("image"));
card.setUserName(rs.getString("UserName"));
card.setTitle(rs.getString("Title"));
card.setKyeword(rs.getString("Keyword"));
card.setContent(rs.getString("Content"));
card.setPassOrNot(rs.getBoolean("PassOrNot"));
card.setCName(rs.getString("CName"));
card.setCount(rs.getInt("Counnt"));
card.setCPath(rs.getString("CPath"));
card.setTitleDetail(rs.getString("TitleDetail"));
card.setTuiJian(rs.getString("TuiJian"));
card.setDate(rs.getString("Date"));
card.setZuozhe(rs.getString("zuozhe"));
card.setSouce(rs.getString("Souce"));
vc.add(card);
}
return vc;
}
catch(SQLException e){return null;}
}
public Vector getAllNotPassCard(int pagenum)
{
int begin = 0;
begin = (pagenum-1)*8;
PreparedStatement pre;
String sql = "select * from cardinf where PassOrNot = ? limit " + begin + ",8";
Vector vc = new Vector();
try
{
pre = con.prepareStatement(sql);
pre.setBoolean(1, false);
//pre.setBoolean(2, false);
ResultSet rs = pre.executeQuery();
while(rs.next())
{
Card card = new Card(rs.getInt("CardID"));
card.setFileName(rs.getString("image"));
card.setUserName(rs.getString("UserName"));
card.setTitle(rs.getString("Title"));
card.setKyeword(rs.getString("Keyword"));
card.setContent(rs.getString("Content"));
card.setPassOrNot(rs.getBoolean("PassOrNot"));
card.setCName(rs.getString("CName"));
card.setCount(rs.getInt("Counnt"));
card.setCPath(rs.getString("CPath"));
card.setTitleDetail(rs.getString("TitleDetail"));
card.setTuiJian(rs.getString("TuiJian"));
card.setDate(rs.getString("Date"));
card.setZuozhe(rs.getString("zuozhe"));
card.setSouce(rs.getString("Souce"));
vc.add(card);
}
return vc;
}
catch(SQLException e){return null;}
}
public int getNPCardCount()
{
int count = 0;
String sql = "select count(*) from cardinf where PassOrNot=false";
try
{
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
count = rs.getInt(1);
}
System.out.println("All notpasscard count is:"+count);
return count;
}
catch(SQLException e){return 0;}
}
public Vector getKeyWord(String inputKeyWord)
{
if(inputKeyWord!="")
{
Vector vc = new Vector();
//int count = 0;//查找结果数
String temp="";//查找结果标题
try
{
//String sql = "select Title from cardinf where Keyword like '"+inputKeyWord+"%' or Title like '"+inputKeyWord+"%' group by Title";
String sql = "select Keyword from cardinf where PassOrNot =true and Keyword like '%"+inputKeyWord+"%'";
//String sql2 = "select count(Title) from cardinf where Title = ?";
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
String[] str = null;
while(rs.next())
{
temp = rs.getString("Keyword");
if(temp.indexOf(" ")!=-1)
{
str = temp.split(" ");
for(int i = 0; i < str.length;++i)
{
if(str[i].startsWith(inputKeyWord))
vc.add(str[i]);
}
}
else if(temp.startsWith(inputKeyWord))
vc.add(temp); //标题 数量
else
;
}
return vc;
}
catch(SQLException e)
{
System.out.println("getKeyWord error!");
return null;
}
}
return null;
}
public Vector getLikeCard(int CardID,String Keyword)
{
Vector vc = new Vector();
//String temp = "";
String sql = "select CardID,Title ,UserName from cardinf where PassOrNot =true and CardID !=" + CardID + " and Keyword like '%"+Keyword+"%' order by Date desc" ;
try
{
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
//Card card = new Card(rs.getInt("CardID"));
//card.setTitle(rs.getString("Title"));
//card.setUserName(rs.getString("UserName"));
//vc.add(card);
vc.add(String.valueOf(rs.getInt("CardID"))+","+rs.getString("Title")+","+rs.getString("UserName"));
}
}
catch(SQLException e)
{
System.out.println("getLikeCard error");
return null;
}
return vc;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -