bugbean.java

strutsBUG管理系统

package com.yourcompany.struts.action;

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

public class BugBean {
	
	public static final String DRIVER="sun.jdbc.odbc.JdbcOdbcDriver";
//	public static final String DBURL="jdbc:odbc:test";
	public static final String DBURL="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=c:/test.mdb";
	Connection conn;
	Statement stmt;
	ResultSet rst;

	public BugBean() {
		try {
			Class.forName(DRIVER);
			System.out.println("Driver...");
			conn=DriverManager.getConnection(DBURL,"","");
			System.out.println("DBURL...");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void setBug(String bugID,String bugOwner){
//		Vector vBug=null;
		String sql="update bug set bugOwner='" +bugOwner+ "' where bugID ='" + bugID + "'";
		try {
			 stmt=conn.createStatement();
			 stmt.executeUpdate(sql);
//			 System.out.println("SetBug...");
			 rst = stmt.executeQuery("select * from bug");
			 if(rst.next()){
//				 System.out.println(rst.getString("bugOwner")+"##"+rst.getString("bugID"));
			 }
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	
	public void addBug(String bugOwner,String bugID,String description){
//		String sql="insert into bug(bugOwner,bugID,description) values" +
//				"(" +bugOwner+ "','"+bugID+"','"+description+"')";
		try {
			stmt=conn.createStatement();
			stmt.executeUpdate("insert into bug (bugOwner,bugID,description) values " +
					"('" + bugOwner + "','" + bugID + "','" + description +"')");
			rst = stmt.executeQuery("select * from bug");
			while(rst.next()){
//				System.out.println("##"+rst.getString("bugID"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	
	public String selectBug(String bugID){
		String owner="";
		String sql="select bugOwner from bug where bugID='"+bugID+"'";
		try {
			 stmt=conn.createStatement();
			 rst = stmt.executeQuery(sql);
			 if(rst.next()){
				 owner=rst.getString("bugOwner");
//				 System.out.println(owner);
			 }
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return owner;
	}
	
	public void deleteBug(String bugID){
		String sql="delete from bug where bugID='"+bugID+"'";
		String str;
		try {
			 stmt=conn.createStatement();
			 stmt.executeUpdate(sql);
			 rst=stmt.executeQuery("selete * from bug");
//			 while(rst.next()){
//				 str=rst.getString("bugID");
////				 System.out.println(str);
//			 }
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
//	public static void main(String args[]){
//		BugBean b=new BugBean();
//		b.addBug("bbbb", "bbbb", "bbbb");
//		
//	}

}