搂住不要担心,只要你在使用数据库连接的方法结尾关闭连接就行了,多用户使用也不会出现太多连接的。
final static String DBDriver="oracle.jdbc.driver.OracleDriver";
final static String ConnStr="jdbc:oracle:thin:@192.168.4.141:1521:ordr";
final static String db_User="ordrdba";
final static String db_Password="oracle";
public Connection getConnection(){
Connection con=null;
try{
Class.forName(DBDriver);
con=DriverManager.getConnection(ConnStr,db_User,db_Password);
}
catch(Exception e){
System.out.println("connection db failed: "+e.toString());
}
return con;
}
public class Message extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
public void init() throws ServletException
{
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException
{
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
String driver = "org.gjt.mm.mysql.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/news";
String user = "";
String password = "";