contactbean.java

基于WEB的商品管理系统

/*
 * ContactBean.java
 *
 * Created on 2007年10月25日, 下午3:23
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package org.me.product;

import java.sql.*;
/**
 *
 * @author Administrator
 */
public class ContactBean {
    
    /** Creates a new instance of ContactBean */
            private Connection con;
            
            //初始化连接。
            public ContactBean() {
                String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
                String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev";
                String USER="sa";
                String PWD="0"; 
                try
                {
	    	
                    Class.forName(CLASSFORNAME);
                    con = DriverManager.getConnection(SERVANDDB,USER,PWD);
                }
                catch(Exception e)
                {
                    e.printStackTrace();
                }
            }
	//在数据库中添加信息
            public void addContact()throws Exception{
                try
		{
			PreparedStatement pstmt=con.prepareStatement("insert into Contact values(?,?,?,?,?,?)");
			pstmt.setString(1,"hellking");
                        pstmt.setInt(2,136234234);
                        pstmt.setString(3,"010455554");
                        pstmt.setString(4,"[e-mail]");
                        pstmt.setDate(5,new java.sql.Date(new java.util.Date().getTime()));
                        pstmt.setString(6,"other email:[e-mail]");
                        pstmt.execute();			
		//	con.close();
		 }
		catch(Exception e)
		{
			e.printStackTrace();
			throw e;
		}
            }
	//查询数据库
	public  ResultSet getContact(String userName)
	{
		try
		{
			Statement stm=con.createStatement();
			ResultSet result=stm.executeQuery("select * from contact where userName='"+userName+"'");
			return result;
		}
		catch(Exception e)
		{
		}
		return null;
	}
    
}