contactbean.java

来自「一个超市管理系统,提供一些基本简单的操作,JSP+APACHE+ORCALE实现」· Java 代码 · 共 66 行

package com.jspdev.ch12;
import java.sql.*;

public class 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="bn";
	    String PWD="bn"; 
	    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;
	}
}