dataquery.java

Ajax自动提示功能 实现类似google suggest的功能

package cn.edu.auto;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import java.sql.*;
import javax.naming.InitialContext;
import javax.sql.DataSource;

/**
 * @author Administrator
 *
 */
public class DataQuery {
        public Connection getConnection() throws Exception{
                String CLASSFORNAME = "com.mysql.jdbc.Driver";
                String SERVERDB = "jdbc:mysql://localhost:3306/auto?useUnicode=true&characterEncoding=utf-8";
                String user = "root";
                String passwd = "root";
                Connection conn;
                try{
                        Class.forName(CLASSFORNAME);
                        conn = DriverManager.getConnection(SERVERDB,user,passwd);
                        return conn;
                }catch(Exception e){
                        e.printStackTrace();
                        return null;
                }
        }
}