📄 birthjdbc.java
字号:
package hm23;
import java.sql.*;
public class BirthJdbc
{
int flag=0;
int number=0;
int pagenumber=1;
int total=0;
String pagestr="1";
String id="";
String password="";
String rpassword="";
String name="";
String sex="";
int nian=0;
int yue=0;
int ri=0;
int qq=0;
String email="";
String sheng="";
String shi="";
String message="";
Connection con;
Statement sql;
ResultSet rs;
StringBuffer news=new StringBuffer();
String sexs="";
public BirthJdbc()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:birth","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
}
catch(ClassNotFoundException e)
{
}
catch(SQLException e)
{
}
}
public void clean()
{
id="";
password="";
rpassword="";
name="";
sex="";
nian=0;
yue=0;
ri=0;
qq=0;
email="";
sheng="";
shi="";
message="";
}
public void setNumber(int x)
{
number=x;
}
public int getNumber()
{
return number;
}
public void setTotal(int x)
{
total=x;
}
public int getTotal()
{
return total;
}
public void setPagenumber(int x)
{
pagenumber=x;
}
public int getPagenumber()
{
return pagenumber;
}
public void setPagestr(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
pagestr=new String(b);
}
catch(Exception e)
{
}
}
public String getPagestr()
{
return pagestr;
}
public void setId(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
id=new String(b);
}
catch(Exception e)
{
}
}
public String getId()
{
return id;
}
public void setPassword(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
password=new String(b);
}
catch(Exception e)
{
}
}
public String getPassword()
{
return password;
}
public void setRpassword(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
rpassword=new String(b);
}
catch(Exception e)
{
}
}
public String getRpassword()
{
return rpassword;
}
public void setName(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
name=new String(b);
}
catch(Exception e)
{
}
}
public String getName()
{
return name;
}
public void setSex(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
sex=new String(b);
}
catch(Exception e)
{
}
}
public String getSex()
{
return sex;
}
public void setNian(int x)
{
nian=x;
}
public int getNian()
{
return nian;
}
public void setYue(int x)
{
yue=x;
}
public int getYue()
{
return yue;
}
public void setRi(int x)
{
ri=x;
}
public int getRi()
{
return ri;
}
public void setQq(int x)
{
qq=x;
}
public int getQq()
{
return qq;
}
public void setEmail(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
email=new String(b);
}
catch(Exception e)
{
}
}
public String getEmail()
{
return email;
}
public void setSheng(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
sheng=new String(b);
}
catch(Exception e)
{
}
}
public String getSheng()
{
return sheng;
}
public void setShi(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
shi=new String(b);
}
catch(Exception e)
{
}
}
public String getShi()
{
return shi;
}
public void setMessage(String x)
{
try
{
byte b[]=x.getBytes("ISO-8859-1");
message=new String(b);
}
catch(Exception e)
{
}
}
public String getMessage()
{
return message;
}
public void setFlag(int x)
{
flag=x;
}
public int getFlag()
{
return flag;
}
public void setNews(StringBuffer x)
{
news=x;
}
public StringBuffer getNews()
{
return news;
}
public void setSexs(String x)
{
sexs=x;
}
public String getSexs()
{
return sexs;
}
public int checkIn()
{
flag=0;
String condition="select * from member where id="+"'"+id+"'"+"and password="+"'"+password+"'";
try
{
con=DriverManager.getConnection("jdbc:odbc:birth","","");
if(id.length()==0||password.length()==0)
{
flag=1;
id="";
password="";
}
else
{
try
{
rs=sql.executeQuery(condition);
}
catch(SQLException e)
{
System.out.println(e);
}
if(rs.next()==false)
{
flag=2;
id="";
password="";
con.close();
}
nian=rs.getInt("nian");
yue=rs.getInt("yue");
ri=rs.getInt("ri");
}
}
catch(SQLException e)
{
System.out.println(e);
}
return flag;
}
public int regCheck()
{
flag=0;
String s="'"+id+"'"+","+"'"+password+"'"+","+"'"+name+"'"+","+"'"+sex+"'"+","+"'"+nian+"'"+","+"'"+yue+"'"+","+"'"+ri+"'"+","+"'"+qq+"'"+","+"'"+email+"'"+","+"'"+sheng+"'"+","+"'"+shi+"'"+","+"'"+message+"'";
String condition="select * from member where id="+"'"+id+"'";
try
{
if(!password.equals(rpassword))
{
flag=3;
this.clean();
}
else if(id.length()==0||password.length()==0||name.length()==0||sex.length()==0||nian==0||yue==0||ri==0||qq==0||email.length()==0||sheng.length()==0||shi.length()==0||message.length()==0)
{
flag=1;
this.clean();
}
else
{
try
{
rs=sql.executeQuery(condition);
}
catch(SQLException e)
{
}
if(rs.next()==true)
{
flag=2;
}
else
{
condition="insert into member(id,password,name,sex,nian,yue,ri,qq,email,sheng,shi,message) values"+"("+s+")";
sql.executeUpdate(condition);
}
}
}
catch(SQLException e)
{
}
return flag;
}
public void showNew()
{
news=new StringBuffer();
String condition="select * from member order by number desc";
if(pagestr==null)
{
pagestr="1";
}
try
{
rs=sql.executeQuery(condition);
int pagesize=15;
rs.last();
int max=rs.getRow();
total=rs.getRow()%pagesize==0?(rs.getRow()/pagesize):(rs.getRow()/pagesize+1);
if(pagestr.equals("上一页"))
{
if(pagenumber==1)
{
pagenumber=1;
}
else
{
pagenumber--;
}
}
else if(pagestr.equals("下一页"))
{
if(pagenumber==total)
{
pagenumber=total;
}
else
{
pagenumber++;
}
}
else
{
pagenumber=Integer.parseInt(pagestr);
}
rs.beforeFirst();
if(pagenumber!=1)
{
rs.absolute((pagenumber-1)*pagesize);
}
for(int i=1;(i<=pagesize)&&(rs.next());i++)
{
news.append("<tr>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("name")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("nian")+"年"+rs.getString("yue")+"月"+rs.getString("ri")+"日"+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sex")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sheng")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("shi")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("qq")+"</div></td>");
news.append("<td>"+"<div align=\"center\"><a href=\"member.jsp?number="+rs.getString("number")+"\"><img src=\"wzh.gif\" width=\"18\" height=\"13\" align=\"middle\"></a></div>"+"</div></td>");
news.append("</tr>");
}
}
catch(SQLException e)
{
System.out.println(e);
}
}
public void showNyr()
{
news=new StringBuffer();
String condition="";
if(sexs==null)
{
sexs="";
}
if(sexs.length()==0)
{
condition="select * from member where nian="+nian+" and "+"yue="+yue+" and "+"ri="+ri+" order by number desc";
}
else if(sexs.length()==3)
{
condition="select * from member where nian="+nian+" and "+"yue="+yue+" and "+"ri="+ri+" and "+"sex="+"'"+"男"+"'"+" order by number desc";
}
else if(sexs.length()==2)
{
condition="select * from member where nian="+nian+" and "+"yue="+yue+" and "+"ri="+ri+" and "+"sex="+"'"+"女"+"'"+" order by number desc";
}
try
{
rs=sql.executeQuery(condition);
while(rs.next())
{
news.append("<tr>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("name")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("nian")+"年"+rs.getString("yue")+"月"+rs.getString("ri")+"日"+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sex")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sheng")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("shi")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("qq")+"</div></td>");
news.append("<td>"+"<div align=\"center\"><a href=\"member.jsp?number="+rs.getString("number")+"\"><img src=\"wzh.gif\" width=\"18\" height=\"13\" align=\"middle\"></a></div>"+"</div></td>");
news.append("</tr>");
}
}
catch(SQLException e)
{
System.out.println(e);
}
}
public void showYr()
{
news=new StringBuffer();
String condition="";
if(sexs==null)
{
sexs="";
}
if(sexs.length()==0)
{
condition="select * from member where yue="+yue+" and "+"ri="+ri+" order by number desc";
}
else if(sexs.length()==3)
{
condition="select * from member where yue="+yue+" and "+"ri="+ri+" and "+"sex="+"'"+"男"+"'"+" order by number desc";
}
else if(sexs.length()==2)
{
condition="select * from member where yue="+yue+" and "+"ri="+ri+" and "+"sex="+"'"+"女"+"'"+" order by number desc";
}
try
{
rs=sql.executeQuery(condition);
while(rs.next())
{
news.append("<tr>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("name")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("nian")+"年"+rs.getString("yue")+"月"+rs.getString("ri")+"日"+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sex")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("sheng")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("shi")+"</div></td>");
news.append("<td><div align=\"center\" class=\"style1\">"+rs.getString("qq")+"</div></td>");
news.append("<td>"+"<div align=\"center\"><a href=\"member.jsp?number="+rs.getString("number")+"\"><img src=\"wzh.gif\" width=\"18\" height=\"13\" align=\"middle\"></a></div>"+"</div></td>");
news.append("</tr>");
}
}
catch(SQLException e)
{
System.out.println(e);
}
}
public void getMember()
{
String condition="select * from member where number="+number+" order by number desc";
news=new StringBuffer();
try
{
rs=sql.executeQuery(condition);
while(rs.next())
{
news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">姓名：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("name")+"</div></td></tr>");
news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">性别：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("sex")+"</div></td></tr>");
news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">出生日期：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("nian")+"年"+rs.getString("yue")+"月"+rs.getString("ri")+"日"+"</div></td></tr>");
news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">QQ：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("qq")+"</div></td></tr>");
news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">E-MAIL：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("email")+"</div></td></tr>");
news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">所在省：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("sheng")+"</div></td></tr>");
news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">所在市：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("shi")+"</div></td></tr>");
news.append("<tr><td width=\"67\"><div align=\"center\" class=\"style1\">签名：</div></td><td width=\"423\"><div align=\"center\" class=\"style1\">"+rs.getString("message")+"</div></td></tr>");
}
}
catch(SQLException e)
{
System.out.println(e);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -