myconnection.java

关于网上汽车销售系统的详细编程项目实战实例

package com.company.manager.tool;

import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;

import com.company.struts.form.returnmoney.ConsignBillForm;
import com.company.struts.form.returnmoney.WareMoneyBillForm;

public class MyConnection {
	private Connection con=null;
	private Statement stm=null;
	private ResultSet rs=null;
	public Connection getConnection(){
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=salesystem";
			con = (Connection) DriverManager.getConnection(url, "sa", "sa");
			
		}catch(Exception e){
			System.out.println("数据库连接失败！");
			e.printStackTrace();
		}
		return con;
	}
	
	
	
	public List findData(String sql){
		con = getConnection();
		List  list = null;
		ConsignBillForm cbform = new ConsignBillForm();
		
		try{
		    stm = con.createStatement();
			rs=stm.executeQuery(sql);
			int i=1;
			while(rs.next())
			{
			   cbform.setC_rowvalue(i);
			   cbform.setC_billCode(rs.getInt(1));
			   cbform.setC_billDate(rs.getDate(2));
			   cbform.setC_money(rs.getDouble(3));
			   System.out.println("aaaaaaaaaaa"); 
			   cbform.setC_notWareMoney(rs.getDouble(4));
			   cbform.setC_warename(selectwareName(rs.getInt(5)));
			   byte b='n';
			   cbform.setC_sellAll(b);
			   System.out.println("ccccccccccc");
			   
			   list.add((Object)cbform);
			   /*list.add(i,(Object)cbform);*/
			  
			   System.out.println("eeeeeeeeeeeeeee");
			   i++;  
			 }   
		}catch(Exception e){
			System.out.println("数据查询失败！");
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				stm.close();
				con.close();
			} catch (SQLException e) {
			
				e.printStackTrace();
			}
		}
		return list;
	}

	public List findData2(String sql){
		con = getConnection();
		List  list1 = null;
		WareMoneyBillForm cbform = new WareMoneyBillForm();
		System.out.println("进入findData2中");
		try{
		    stm = con.createStatement();
			rs=stm.executeQuery(sql);
			int i=1;
			while(rs.next())
			{
				System.out.println("hhhhhhhhhh");
			   cbform.setRowvalue(i);
			   cbform.setBillCode(rs.getInt(1));
			   System.out.println(rs.getInt(1));
			   cbform.setBillDate(rs.getDate(2));
			   System.out.println(rs.getDate(2));
			   cbform.setMoney(rs.getDouble(3));
			   System.out.println(rs.getDouble(3));
			   cbform.setNotwaremoney(rs.getDouble(4));
			   System.out.println(rs.getDouble(4));
			   list1.add((Object)cbform);
			   i++;
			   System.out.println("kkkkkkkkkkkk");
			 }
			   
		}catch(Exception e){
			System.out.println("数据查询失败2！");
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				stm.close();
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return list1;
	}
	 
	 //根据货物Code 取得货物名称
	 String selectwareName(int code){
		String sql ="select wareName from Gy_Material where wareCode="+code;
		con = getConnection();
		String str=null;
		try{
			rs=stm.executeQuery(sql);
			if(rs.next()){
				str = rs.getString(1);
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		return str;
	 }
}