query,java

这是关于java 界面设计的东西 可能有帮住

/**
 * Summary description for Query.
 */
public class Query
{
	private Connection conn = null;

	public Query()
	{}
	public static void getConnection() 
	{
		Connection conn = null;
		dbtype = "access";
		try 
		{

			// 连接ODBC数据源
			String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
			String connectString = "jdbc:odbc:myDb";
			String username = "sa";
			String password = "sa";
			Class.forName(driver).newInstance();
			conn = DriverManager.getConnection(connectString, username,
				password);
			// 建立连结
			

		} 
		catch (SQLException e) 
		{// 捕获异常
			e.printStackTrace();
		} 
		catch (Exception e) 
		{// 捕获异常
			e.printStackTrace();
		}
	this.conn=conn;
	}

	/**
	 * 关闭数据库连接对象
	 * 
	 * @param conn
	 */
	public static void closeConnection(Connection conn) 
	{
		try 
		{
			conn.close(); // 关闭连接
		} 
		catch (SQLException ex) 
		{
			ex.printStackTrace();
		}

	}


	public static void Delete() 
					   {
						 
						   Connection conn = getConnection();
						   PreparedStatement stmt;
						   try 
						   {
							   //stmt = conn.prepareStatement("delete  from [user] ");
							   stmt = conn.prepareStatement("delete  from mytable where ID = ? ");
							   stmt.setString(1, "FF");
							   stmt.execute();
							   stmt.close();
							  // conn.commit();
							   //closeConnection(conn);
						   } 
						   catch (SQLException e) 
						   {
							   // TODO Auto-generated catch block
							   e.printStackTrace();
						   }
		
					   }


	public static void Insert() 
	{
		
		PreparedStatement stmt;
		try 
		{
			stmt = conn.prepareStatement("use student insert into mytable(ID,name,age) values(?,?,?)");
			stmt.setString(1,"FFf");
			stmt.setString(2,"letmeinf");
			stmt.setInt(3,16);
			stmt.execute();
			stmt.close();
			//conn.commit();
			//DB.closeConnection(conn);
		} 
		catch (SQLException e) 
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

	public static void Update() 
					   {
						   
						
						   PreparedStatement stmt;
						   try 
						   {
							   stmt = conn.prepareStatement("use student update mytable set name=? where name=?");
							   stmt.setString(1,"tommm");
							   stmt.setString(2,"张三");
							   stmt.execute();
							   stmt.close();
							 //  conn.commit();
							 // closeConnection(conn);
						   } 
						   catch (SQLException e) 
						   {
							   // TODO Auto-generated catch block
							   e.printStackTrace();
						   }
		
					   }
public static String[] Select {

	/**
	 * @param args
	 */
	
		
		PreparedStatement stmt;
                String[10] result=null;
		try {
			stmt = conn.prepareStatement("use student select * from mytable where ID = ?");
			//stmt.setInt(1, 1);
			stmt.setString(1, "1");
			ResultSet rs = stmt.executeQuery();
                        int n=0;
			while(rs.next()){
				for(int i=1;i<=3;i++)
					result[n]+=rs.getString(i);
				n++;
				
			}

		 return result;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

}



}