?? mainbean.java
字號:
package com.ideas.bean;
import java.lang.*;
import java.util.*;
import java.sql.*;
public class mainBean extends ParentBean
{
String id = "-1";
public void setID(String id)
{
this.id = id;
}
public String login(String loginimg)
{
String sql = "select href from menu1 where loginimg='"+loginimg+"' and isuse='1'";
String href = "";
Vector v = getDataBySql(sql);
if(v.size()==1)
{
href = (String)((Hashtable)v.get(0)).get("href");
}
return href;
}
public Vector getMenu1List()
{
String sql = "select id,rect from menu1 where isuse='1' order by id";
return getDataBySql(sql);
}
public Vector getMenu2List(String menu1id)
{
String sql = "select id,name from menu2 where isuse='1' and id1="+menu1id+" order by id";
return getDataBySql(sql);
}
public Vector getMenu3List(String menu2id)
{
String sql = "select id,name from menu3 where isuse='1' and id2="+menu2id+" order by id";
return getDataBySql(sql);
}
public static void main(String args[]) throws Exception
{
mainBean mb = new mainBean();
//連接數(shù)據(jù)庫
//mb.createConn("org.gjt.mm.mysql.Driver","jdbc:mysql://localhost:3306/yj","admin","admin");
mb.createConn(7,"localhost","3306","","hpj","admin","admin");
//System.out.println(mb.add(hash));
//取得當前也的數(shù)據(jù)
System.out.println(mb.login("body_roll_01.gif"));
//取得記錄數(shù)
//System.out.println(mb.getResultSetData(mb.selectRecord("select count(*) from snals")));
//釋放連接
System.out.println("\r\n\r\nend");
}
};
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -