java ajax 修改数据库数据库数据库_AJAX 自学练习 无刷新提交并修改数据库数据并显...

package com.lwf.eus.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.sql.DataSource;

public class ConnectionManager {

public static Connection getConnection(){

Connection conn = null;

String url = "jdbc:postgresql://192.168.0.180/getseus";

String userName = "getsdbadmin";

String pwd = "powerdb";

try {

Class.forName("org.postgresql.Driver").newInstance();

conn = DriverManager.getConnection(url,userName,pwd);

} catch (SQLException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (InstantiationException e) {

e.printStackTrace();

} catch (IllegalAccessException e) {

e.printStackTrace();

} catch (Exception e){

e.printStackTrace();

}

return conn;

}

public static Connection getConnectionFromDS(){

Connection conn = null;

Context ctx = null;

try {

ctx = new InitialContext();

DataSource ds = (DataSource)ctx.lookup("JNDIPG");

conn = ds.getConnection();

} catch (NamingException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

public static Statement createStatement(Connection conn){

Statement st = null;

try {

st = conn.createStatement();

} catch (SQLException e) {

e.printStackTrace();

}

return st;

}

}

这就是微学网-程序员之家为你提供的"AJAX 自学练习 无刷新提交并修改数据库数据并显"希望对你有所帮助.本文来自网络，转载请注明出处：http://www.weixuecn.cn/article/5345.html