dwrdemo.java

这是一个网上书站的例子

package com.ajax;

import java.sql.ResultSet;
import java.sql.SQLException;
import com.db.Jdo;




public class DwrDemo {
	public boolean modifyCatalogb(int id,String catalogname)//修改大类型表
	{
		Jdo jdo=new Jdo();
		jdo.executeUpdate("update bigcatalog set catalogname='"+catalogname+"' where bigcatalogid="+id);
		jdo.destroy();
		return true;
	}
	public boolean modifyCatalogs(int id,String catalogname,int bigcatalogid)//修改小类型表中的内容
	{
		Jdo jdo=new Jdo();
		
		jdo.executeUpdate("update smallcatalog set catalogname='"+catalogname+"',bigcatalogid='"+bigcatalogid+"' where smallcatalogid="+id);
		
		jdo.destroy();
		
		
		return true;
	}
	public String getSmallCatalog(int id)//根据大种类的值取出所有的小种类
	{
		Jdo jdo=new Jdo();
		
		ResultSet rs=jdo.executeQuery("select * from smallcatalog where bigcatalogid="+id);
		
		String buffer="";
		buffer+="小类别：<select name=\"types\">";
		try {
			while(rs.next())
			{
				//<option value="<%=id %>" ><%=catalogname %></option>
				
				int smallcatalogid=rs.getInt("smallcatalogid");
				String catalogname=rs.getString("catalogname");
				buffer=buffer+"<option value=\""+smallcatalogid+"\">"+catalogname+"</option>";
				rs.next();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		buffer+="</select>";
		jdo.destroy();
		return buffer;
	}
	public boolean userIsExist(String username)//判断USER表中的用户名是否存在，在注册时用得上
	{
		Jdo jdo=new Jdo();
		int count=jdo.rowCount("select count(*) from user where username='"+username+"'");
		if(count>0)
		{
			jdo.destroy();
			return true;
			
		}
		else
		{
			jdo.destroy();
			return false;
		}
		
		
	}
	public void register(String city,String username,String password,String sex,String address,String truename,String phone)//user注册时用的
	{
		Jdo jdo=new Jdo();
		jdo.executeUpdate("insert into user(city,username,password,usersex,useraddress,userphone,truename) values('"+city+"','"+username+"','"+password+"','"+sex+"','"+address+"','"+phone+"','"+truename+"')");
		jdo.destroy();
	}
	public void update(String city,String username,String password,String sex,String address,String truename,String phone)//uer修改时用的
	{
		Jdo jdo=new Jdo();
		jdo.executeUpdate("update user set city='"+city+"',password='"+password+"',usersex='"+sex+"',useraddress='"+address+"',userphone='"+phone+"',truename='"+truename+"' where username='"+username+"'");
		jdo.destroy();
	}
	
	public void setOrderStatus(String ordernum)
	{
		Jdo jdo=new Jdo();
		jdo.executeUpdate("update orderw set issend=1 where ordernumber="+ordernum);
		jdo.destroy();
	}
	public void adminUpdateUser(String userid,String password)//admin修改user修改时用的
	{
		Jdo jdo=new Jdo();
		jdo.executeUpdate("update user set password='"+password+"' where userid="+userid);
		jdo.destroy();
	}
	
	public void modifyAdmin(String name,String pass)
	{
		Jdo jdo=new Jdo();
		jdo.executeUpdate("update admin set password='"+pass+"' where adminname='"+name+"'");
		jdo.destroy();
	}
	
	public static void main(String args[])
	{
		DwrDemo dwrDemo=new DwrDemo();
		//boolean d=dwrDemo.userIsExist("zx1");
		//dwrDemo.setOrderStatus("1200811211838671");
		dwrDemo.modifyAdmin("zxf", "1985");
		//System.out.print(d);
	}
}