aaa.rar_wwwaaa 446com

package zc; import java.awt.List; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import javax.xml.crypto.Data; public class DB { private String content; public Connection getconn(){ Connection conn=null; try{ //加载驱动类 Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/a","root","123456"); } catch (Exception e){ e.printStackTrace(); } return conn; } public boolean check(String name,String pwd){ //活动数据库的链接 Connection con=getconn(); try{ Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from a.usertable where username='"+name+"' and passwd='"+pwd+"'"); if(rs.next())//有记录 return true; } catch (Exception e){ e.printStackTrace(); } return false; }//从lytable中获得所有的记录，已list集合对象返回 public ArrayList getAllLyInfo(){ ArrayList list=new ArrayList(); //从lytable中活动所以的记录 Connection con=getconn(); try{ Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from lytable "); //提取记录集中的记录，放入LIST对象中 while (rs.next()){ //有记录 LyBean ly =new LyBean(); ly.setId(rs.getInt("id")); ly.setUserId(rs.getInt("userid")); ly.setData(rs.getString("data")); ly.setTitle(rs.getString("title")); ly.setContent(rs.getString("content")); list.add(ly); } }catch (Exception e){ e.printStackTrace(); } return list; } @SuppressWarnings("deprecation") public String getUsernameById(int id){ String name; //活动数据库的链接 Connection con=getconn(); try{ Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from a.usertable where id="+id); if(rs.next()) return rs.getString("username"); } catch (Exception e){ e.printStackTrace(); } return ""; } @SuppressWarnings("deprecation") public int getRightById(int id){ Connection con=getconn(); try{ Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from a.usertable where id="+id); if(rs.next()) return rs.getInt("right"); } catch (Exception e){ e.printStackTrace(); } return 0; } public boolean addLy(String name, String title,String content) { // TODO Auto-generated method stub Calendar c=Calendar.getInstance();//获得系统当前日期 String year=String.valueOf(c.get(Calendar.YEAR)), month =String.valueOf(c.get(Calendar.MONTH)+1),//系统日期从0开始算起 day=String.valueOf(c.get(Calendar.DAY_OF_MONTH)); String data=year+"-"+month+"-"+day; int userId=getUserIdByName(name); Connection con=getconn(); try{ Statement stmt=con.createStatement(); int n=stmt.executeUpdate("insert into lytable(userId,data,title,content) values('"+userId+"','"+data+"','"+title+"','"+content+"')"); if(n>0) return true; } catch (Exception e){ e.printStackTrace(); } return false; } public int getUserIdByName(String name) { // TODO Auto-generated method stub Connection con=getconn(); try{ Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from a.usertable where username='"+name+"'"); if(rs.next())//有记录 return rs.getInt("id"); } catch (Exception e){ e.printStackTrace(); } return 0; } private void getInt(String string) { // TODO Auto-generated method stub } public boolean RegisterForm(String name, String pwd1,String pwd2) { // TODO Auto-generated method stub Connection con=getconn(); try{ Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select max(id) maxid from usertable"); rs.next(); int id=rs.getInt("maxid")+1; int add=stmt.executeUpdate("insert into usertable(id,username,passwd) values('"+id+"','"+name+"','"+pwd1+"')"); if(add>0) return true; } catch (Exception e){ e.printStackTrace(); } return false;} public java.util.List getSearchLyInfo(String searchText) { ArrayList list=new ArrayList(); Connection con=getconn(); try{ Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from lytable where title like '%"+searchText+"%'"); //提取记录集中的记录，放入LIST对象中 while (rs.next()){ //有记录 LyBean ly =new LyBean(); ly.setId(rs.getInt("id")); ly.setUserId(rs.getInt("userid")); ly.setData(rs.getString("data")); ly.setTitle(rs.getString("title")); ly.setContent(rs.getString("content")); list.add(ly); } }catch (Exception e){ e.printStackTrace(); } return list; } public void deleteLyInfo(String id) { // TODO Auto-generated method stub Connection con=getconn(); try{ Statement stmt=con.createStatement(); stmt.executeUpdate("delete from lytable where id='"+id+"'"); }catch(Exception e){ e.printStackTrace(); } } }