conndb.java

ajax 中流行框架dwr 本人写的官方的例子。。。不容错过对Ajax的同学。

package com.kongnan.benn;

import java.sql.*;

public class ConnDB {

	  public static Connection conn;
	  public static Statement stmt;
	  public static ResultSet rs;
	  public static String url = "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=pubs";
	  public static String username="sa";
	  public static  String pass = "sa";

	  public ConnDB() {
	  }

	  public static Connection getConn(){
	   try {
	     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	    conn = DriverManager.getConnection(url, username, pass);
	   }
	   catch (ClassNotFoundException ex) {
	   }catch (SQLException ex1) {
	   }
	   return conn;
	 }
	
}