usebean.java

来自「我们做的J2EE课程设计实验,使用JSF语言编写一个简易的订单系统,麻雀虽小五脏」· Java 代码 · 共 57 行

package ch6;
import java.sql.*;
public class useBean 
{
	public Connection con;
	//初始化连接。
	public useBean()
	{
	String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	String SERVANDDB="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Result";
	String USER="sa";
	String PWD="bigtwo863158"; 
	try
	{
	
    Class.forName(CLASSFORNAME);
	con = DriverManager.getConnection(SERVANDDB,USER,PWD);
	}
	catch(Exception e)
	{
	//System.out.println("slkdjf");
	e.printStackTrace();
	}
	}
	//在数据库中添加信息
	
	//查询数据库
	public ResultSet getorder()
	{
	try
	{
	Statement stm=con.createStatement();
	ResultSet result=stm.executeQuery("select * from t_order");
	//System.out.println("slkdjf");
	return result;
	}
	catch(Exception e)
	{
		return null;
	}
	}
	public ResultSet getorderitem()
	{
		try
		{
		Statement stm=con.createStatement();
		ResultSet result=stm.executeQuery("select * from t_order");
		//System.out.println("slkdjf");
		return result;
		}
		catch(Exception e)
		{
			return null;
		}
	}
}