jdbcservlet.java

来自「一个简单的Ext例子」· Java 代码 · 共 64 行

package com.utils.servlet;


import java.sql.*;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;

public class JDBCServlet extends HttpServlet {

	private Connection conn;
	/**
	 * Constructor of the object.
	 */
	public JDBCServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
		//String driverName = "com.mysql.jdbc.Driver";
		//String url = "jdbc:mysql://localhost:3306/LEDO?AuseUnicode=true&characterEncoding=GBK";
		String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=LEDOA";
		try {
			Class.forName(driverName).newInstance();
			conn = DriverManager.getConnection(url,"sa","123");
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("select * from Employeer");
			System.out.println(rs.getRow());
			if(conn == null)System.out.println("conn can able use");
		} catch (InstantiationException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (SQLException e){
			e.printStackTrace();
		}
		System.out.println("servlet启动");
	}

	public Connection getConnection(){
		return conn;
	}
}