//用户注册向数库数中增加数据

public static final string registadd_tb_user ="insert into tb_user (user_name,user_password,realname,email)" +"values( ?, ?, ?, ? )";

// public static final string queryid_tb_user ="select user_id from tb_user where user_name=?";

public static final string registcheck_tb_user="select count(*) from tb_user where user_name=?";

public static final string add_tb_articletype="insert into tb_articletype (typename,description) values(?,?)";

public static final string query_tb_articletype="select * from tb_articletype";

public static final string del_tb_articletype="delete from tb_articletype where type_id=?";

public static final string add_tb_article="insert into tb_article (title,type_id,content,phtime,number) values(?,?,?,?,?)";

public static final string del_tb_article="delete from tb_article where article_id=?";

public static final string query_article="select * from tb_article";

public static final string show_article="select tb_article.*,tb_articletype.* from tb_article,tb_articletype where (tb_article.type_id=tb_articletype.type_id and tb_article.type_id=? and article_id=?)";

public static final string xin="select tb_article.*,typename,description from tb_article left join tb_articletype on (tb_article.type_id=tb_articletype.type_id)";

public static final string add_tb_note="insert into tb_note (note_title,note_content,note_time) values(?,?,?)";

public static final string query_tb_note="select * from tb_note";

public static final string del_tb_note="delete from tb_note where note_id=?";

public static final string show_tb_note="select * from tb_note where note_id=?";

public static final string update_tb_note="update tb_note set note_content=? ,note_time=? where note_id=?";

public static final string update_tb_article= "update tb_article set content=? ,phtime=? where article_id=?";

public static final string query_tb_user = "select user_id,user_name,realname,email from tb_user";

public static final string del_tb_user = "delete from tb_user where user_id=?";

public static final string query_tb_message = "select * from tb_message order by mes_id";

public static final string delone_tb_message = "delete from tb_message where mes_id=?";

public s

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ... 下一页  >>