getresultbyformat.java

用jsp所编写

package com;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;


public class GetResultByFormat {

	 Connection conn;
	    Statement st; 
	    ResultSetMetaData fields;
	
	public  GetResultByFormat() {
		conn_init();	
	}
	
	  
	 private void conn_init() {
	        setConnection();
	        setStatement();
	    }

	  private void setConnection() {
	        try {
	            Class.forName("org.gjt.mm.mysql.Driver");
	            String strurl;
	            strurl = 
	                    "jdbc:mysql://localhost/tumor1";
	            conn = DriverManager.getConnection(strurl,"root","123456");
	        } catch (Exception e) {
	            e.printStackTrace();
	        }
	    }

	    private void setStatement() {
	        try {
	            st = 
	 conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
	        } catch (SQLException e) {
	            e.printStackTrace();
	        }
	    }
	    
	
	//鏁版嵁搴撹仈鎺ュ畬鎴