此处将为大家介绍关于servlet连接mysql数据库和oracle数据库的详细内容，并且为您解答有关servlet与数据库连接的相关问题，此外，我们还将为您介绍关于html文件form表单actio
此处将为大家介绍关于servlet连接mysql数据库和oracle数据库的详细内容，并且为您解答有关servlet与数据库连接的相关问题，此外，我们还将为您介绍关于html文件form表单action调用servlet连接mysql数据库实例、java实现的连接oracle/mysql数据库功能简单示例【附oracle+mysql数据库驱动包】、JDBC连接mysql、sqlserver、oracle数据库示例，含代码、JSP连接MySql/MS SQL Server/Oracle数据库连接方法[整理]的有用信息。
本文目录一览：- servlet连接mysql数据库和oracle数据库（servlet与数据库连接）
- html文件form表单action调用servlet连接mysql数据库实例
- java实现的连接oracle/mysql数据库功能简单示例【附oracle+mysql数据库驱动包】
- JDBC连接mysql、sqlserver、oracle数据库示例，含代码
- JSP连接MySql/MS SQL Server/Oracle数据库连接方法[整理]
servlet连接mysql数据库和oracle数据库（servlet与数据库连接）
连接mysql数据库
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class BaseDao
{
//连接mysql数据库
Connection conn = null;
Statement st = null;
PreparedStatement pst = null;
ResultSet rs = null;
public Connection getConn()
{
try
{
String databaseName = "easynews";//数据库名
String host = "localhost";
String port = "3306";
String username = "root"; //用户AK
String password = "root"; //用户SK
String driverName = "com.mysql.jdbc.Driver";
String dbUrl = "jdbc:mysql://";
String serverName = host + ":" + port + "/";
String connName = dbUrl + serverName + databaseName;//数据库地址jdbc:mysql://localhost:3306/easynews
Class.forName(driverName);
this.conn = DriverManager.getConnection(connName, username, password);
if (this.conn != null) {
System.out.println("数据库连接成功");
} else {
System.out.println("数据库连接失败");
}
}
catch (Exception e)
{
e.printStackTrace();
}
return this.conn;
}
public void closeAll(Statement st, ResultSet rs, Connection conn)
{
try
{
if (st != null) {
st.close();
}
if (rs != null) {
rs.close();
}
if (conn != null) {
conn.close();
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
连接oracle数据库
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class BaseDao
{
String username = "scott";
String password = "tiger";
String url = "jdbc:oracle:thin:localhost:1521:orcl";
String driver = "oracle.jdbc.driver.OracleDriver";
Connection conn = null;
Statement st = null;
PreparedStatement pst = null;
ResultSet rs = null;
public Connection getConn()
{
try
{
Class.forName(this.driver);
this.conn = DriverManager.getConnection(this.url, this.username, this.password);
if (this.conn != null) {
System.out.println("数据库连接成功");
} else {
System.out.println("数据库连接失败");
}
}
catch (Exception e)
{
e.printStackTrace();
}
return this.conn;
}
public void closeAll(Statement st, ResultSet rs, Connection conn)
{
try
{
if (st != null) {
st.close();
}
if (rs != null) {
rs.close();
}
if (conn != null) {
conn.close();
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
html文件form表单action调用servlet连接mysql数据库实例
web.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
version="2.5">
<servlet>
<servlet-name>FootballTeam</servlet-name>
<servlet-class>FindFootOrPk</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>FootballTeam</servlet-name>
<url-pattern>/foot</url-pattern>
</servlet-mapping>
</web-app>
html文件
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>html调用servlet</title>
</head>
<body>
<h1 align="center">请点击提交按钮</h1>
<div align="center" class="footgame">
<form action="http://localhost:8080/ltb6w/foot" name="match" method="post">
<input type="submit" value="提交">
</form>
</div>
</body>
</html>html文件中 action=" " 双引号中调用文件的手段很多,方法很灵活.要特别注意.
举几个栗子:
1 <a href="userAction.do?flag=user_regist">注册</a>
2 例：
<form action="test.do?args=888">
<input type="button" value="submit">
</form>
通过这个方法，test.do无法读取args，必须换成一下写法
<form action="test.do">
<input type="hidden" name="args" value="888">
<input type="button" value="submit">
</form>
3
要在web.xml中配置servlet配置好了后 在form的action中直接写你在web.xml中配置的<url-pattern>的名字。。例如
<servlet>
<servlet-name>AdminLogin</servlet-name>
<servlet-class>
com.java.servlet.AdminLogin
</servlet-class>
<load-on-startup>22</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>AdminLogin</servlet-name>
<url-pattern>/AdminLogin</url-pattern>
</servlet-mapping>
在form的action中就直接写AdminLogin就行了
① 完全匹配
<url-pattern>/test/list.do</url-pattern>
② 路径匹配
<url-pattern>/*</url-pattern> struts2匹配根路径下的全部请求
③ 扩展名匹配
<url-pattern>*.do</url-pattern> struts1
<url-pattern>*.html</url-pattern> 匹配全部html结尾的请求
<url-pattern>*</url-pattern> 不能用*，否则报错
action写web.xml中对应的url值~~~比如说有一个LoginServlet，他在web.xml中显示的应该是这样：
<servlet>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>servlet.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/loginServlet</url-pattern>
</servlet-mapping>
而要提交的，也就是action应该等于<url-pattern>中的内容：
action="<%=request.getContextPath()%>/loginServlet"
其中<%=request.getContextPath()%>为获得当前工程目录，jsp提交到servlet中必须加这个，否则会出现404找不到页的错误~~
例如在web.xml中注册如下的servlet:
<servlet>
<servlet-name>addStudent</servlet-name>
<servlet-class>org.mytest.addStudent</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>addStudent</servlet-name>
<url-pattern>/servlet/addStudent</url-pattern>
</servlet-mapping>
假如说，你工程名字为HibernateApp3，JSP页面提交表单给servlet时有两种写法：
1. <form action=servlet/addStudent method=post>...</form>
2. <form action=/HibernateApp3/servlet/addStudentmethod=post>...</form>
注意：/代表根目录，如果路径是使用/开头，Tomcat就是webApp那个目录，如果你不是/开头代表你从当前工程的目录开始，例如：webApp/HibernateApp3/
这一点非常重要，很多提交表单时发生的错误都是因为提交路径出错造成的。
这些都是从网上收集到的各种回答，总而言之，action的提交路径，和<url-pattern></url-pattern>中的路径保持一致就不会有错，不过是有前提的，就是路径入口处要是指向这个工程的，例如下面这种就是错误：
<form method="get" action="/yutao"> ，，而 <url-pattern>/yutao</url-pattern>，这样提交表单时，就会报404错误：The requested resource is not available。因为前面的“/”，指的是服务器的根目录，也就是Tomcat目录下的webapps。改为：<form method="get" action="/工程名/yutao"，即可。
url-parrern里面放的是servlet访问路径，我目前的结论是这路径随便写都写，当然，注意我上面说的。。。
import java.sql.*;
import java.io.*;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/FindFootOrPk")
public class FindFootOrPk extends HttpServlet {
private static final long serialVersionUID = 1L;
//JDBC驱动名和数据库URL
static final String JDBC_DRIVER="com.mysql.jdbc.Driver";
static final String DB_URL="jdbc:mysql://localhost:3306/dudu";//dudu数据库名称
//数据库用户名和密码
static final String USER="root";
static final String PASS="123456";
/**
* @see HttpServlet#HttpServlet()
*/
public FindFootOrPk() {
super();
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Connection conn=null;
Statement stmt=null;
//设置响应内容类型
response.setContentType("text/html;charset=UTF-8");
PrintWriter out=response.getWriter();
String title="前后端打通,连接数据库,我的世界来啦!";
// String name=request.getParameter("pk");
// String link=request.getParameter("link");
String docType = "<!DOCTYPE html>\n";
out.println(docType +
"<html>\n" +
"<head><title>" + title + "</title></head>\n" +
"<body bgcolor=\"#f0f0f0\">\n" +
"<h1 align=\"center\">" + title + "</h1>\n");
try{
// 注册 JDBC 驱动器
Class.forName("com.mysql.jdbc.Driver");
// 打开一个连接
conn = DriverManager.getConnection(DB_URL,USER,PASS);
out.println("数据库连接成功！");
// 执行 SQL 查询
stmt = conn.createStatement();//
String sql; //foot_ball 数据库表名称
sql = "SELECT*FROM foot_ball"; //sql语句,一定要保证正确.最好测试一下,要不html不显示.
ResultSet rs = stmt.executeQuery(sql); //sql语句执行的结果
// 展开结果集数据库
while(rs.next()){
// 通过字段检索
int id = rs.getInt("id");
String tream = rs.getString("tream");
String url = rs.getString("url");
// 输出数据
out.println("ID: " + id);
out.println(", 球队: " + tream);
out.println(", 站点 URL: " + url);
out.println("<br />");
}
out.println("</body></html>");
// 完成后关闭
rs.close();
stmt.close();
conn.close();
} catch(SQLException se) {
// 处理 JDBC 错误
se.printStackTrace();
} catch(Exception e) {
// 处理 Class.forName 错误
e.printStackTrace();
}finally{
// 最后是用于关闭资源的块
try{
if(stmt!=null)
stmt.close();
}catch(SQLException se2){
}
try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
java实现的连接oracle/mysql数据库功能简单示例【附oracle+mysql数据库驱动包】
这篇文章主要介绍了java实现的连接oracle/MysqL数据库功能,结合实例形式分析了java基于jdbc连接Oracle与MysqL的相关操作技巧,并附带完整实例代码与oracle+MysqL数据库驱动包供读者下载参考,需要的朋友可以参考下
本文实例讲述了java实现的连接oracle MysqL数据库功能。分享给大家供大家参考，具体如下：
package com.nuo.test.Connection; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.sqlException; public class DBUtil{ public static Connection getConnection() throws Exception{ Connection cull; try { Class.forName( //"oracle.jdbc.driver.OracleDriver" "com.MysqL.jdbc.Driver" ); conn=DriverManager.getConnection( //"jdbc:oracle:thin:@127.0.0.1:1521:qiye","jossinfo","tao" "jdbc:MysqL://localhost:3306/care","root","nuo" ); } catch (Exception e) { e.printstacktrace(); throw e; } return conn; } public static void close(Connection conn) throws Exception{ if(conn!=null){ try { conn.close(); } catch (sqlException e) { System.out.println(e); } } } public static void main(String[] args) throws Exception{ ResultSet rs = null; Connection conn = null; String valiresult=""; try{ conn = DBUtil.getConnection(); PreparedStatement prep = conn.prepareStatement( "select * from tab_user " ); rs = prep.executeQuery(); while(rs.next()){ valiresult=rs.getString(1);//表第一列内容 System.out.println(valiresult); } }catch(Exception e){ e.printstacktrace(); throw e; }finally{ DBUtil.close(conn); } } }
附：实例代码与驱动包点击此处本站下载。
更多关于java相关内容感兴趣的读者可查看本站专题：《Java+MysqL数据库程序设计总结》、《Java数据结构与算法教程》、《Java文件与目录操作技巧汇总》、《Java操作DOM节点技巧总结》和《Java缓存操作技巧汇总》
希望本文所述对大家java程序设计有所帮助。
JDBC连接mysql、sqlserver、oracle数据库示例，含代码
【JDBC 连接 mysql】 注意：mysql默认关闭了batch处理，只有把rewriteBatchedStatements参数置为true, 驱动才会批量执行SQL；同时，选项对INSERT/UPDATE/DELETE都有效，只不过对INSERT它为会预先重排一下SQL语句；另外，当batchSize <= 3时，驱动会宁愿一条一条地执行SQL；所以，如果你想验证rewriteBatchedStatements在你的系统里是否已经生效，记得要使用较大的batch。
/** JDBC connect to Mysql **/
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="jdbc:mysql://192.168.190.**:3306/reuri?rewriteBatchedStatements=true";
String user="root";
String password="123qwe";
Connection conn= DriverManager.getConnection(url,user,password);
conn.setAutoCommit(false);
/**
when stmt_type equals 1,produce datas by PreparedStatement class.
when stmt_type equals 2,produce datas by Statement class.
while the sql is called repeatedly, PreparedStatement class will be more ineffective.
84 minutes produce 5000,000 records by useing Statement class;
70.33 seconds produce 5000,000 records by useing PreparedStatement class when bachnum is 1000;
81.50 seconds produce 5000,000 records by useing PreparedStatement class when bachnum is 10000;
67.28 seconds produce 5000,000 records by useing PreparedStatement class when bachnum is 50000;
68.91 seconds produce 5000,000 records by useing PreparedStatement class when bachnum is 100000;
*/
int stmt_type=1;
long start_time = System.currentTimeMillis();
if (stmt_type==1)
{
String pbase_sql="insert into IVR_MENU_INFO (IVR_MENU_ID,CALLER_NUMBER,CALLED_NUMBER,SSP_ID,IVR_MENU_TYPE_CODE,CHANGE_CHOICE)"
+"values (?,?,?,?,?,?)";
PreparedStatement prepared_stmt=conn.prepareStatement(pbase_sql);
String str_[]={",''good''",",''great''",",''wonderful''",",''awesome''",",''fantastic''",",''beautiful''",",''perfect''",",''terrific''"};
for(int i=1;i<=5000000;i++){
int index =(int)(Math.random()*str_.length);
prepared_stmt.setInt(1, i);
prepared_stmt.setString(2, "10");
prepared_stmt.setString(3, "8");
prepared_stmt.setInt(4, i);
prepared_stmt.setString(5, str_[index]);
prepared_stmt.setString(6, "1");
prepared_stmt.addBatch();
if(i%100000==0){
prepared_stmt.executeBatch();
conn.commit();
System.out.println("正在执行第"+i+"条记录！");
}
}
prepared_stmt.close();
}else if(stmt_type==2){
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String base_sql="insert into IVR_MENU_INFO (IVR_MENU_ID,CALLER_NUMBER,CALLED_NUMBER,SSP_ID,IVR_MENU_TYPE_CODE,CHANGE_CHOICE) values (";
String str[]={",''good''",",''great''",",''wonderful''",",''awesome''",",''fantastic''",",''beautiful''",",''perfect''",",''terrific''"};
for(int i=1;i<=5000000;i++){
String insert_sql="";
int index =(int)(Math.random()*str.length);
insert_sql=base_sql+i+",''10''"+",''8'',"+i+str[index]+",''1'')";
stmt.addBatch(insert_sql);
if(i%1000==0){
stmt.executeBatch();
conn.commit();
System.out.println("正在执行第"+i+"条记录！");
}
}
stmt.close();
}
System.out.println("开始时间："+start_time);
System.out.println("结束时间："+System.currentTimeMillis());
conn.close();
}
catch(Exception e)
{
out.println(e);
}
【JDBC 连接 sqlserver】
/** JDBC connect to sqlserver **/
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
String url="jdbc:sqlserver://192.168.***.3:1433; DatabaseName=aaa";
String user="sa";
String password="cailiqiang";
Connection conn= DriverManager.getConnection(url,user,password);
conn.setAutoCommit(false);
long start_time = System.currentTimeMillis();
/**
55.54 seconds produce 1000,000 records by useing PreparedStatement class when bachnum is 1000;
46.49 seconds produce 1000,000 records by useing PreparedStatement class when bachnum is 10000;
45.78 seconds produce 1000,000 records by useing PreparedStatement class when bachnum is 50000;
45.78 seconds produce 1000,000 records by useing PreparedStatement class when bachnum is 100000;
**/
int stmt_type=1;
if (stmt_type==1)
{
String pbase_sql="insert into IVR_MENU_INFO (IVR_MENU_ID,CALLER_NUMBER,CALLED_NUMBER,SSP_ID,IVR_MENU_TYPE_CODE,CHANGE_CHOICE)"
+"values (?,?,?,?,?,?)";
PreparedStatement prepared_stmt=conn.prepareStatement(pbase_sql);
String str_[]={",''good''",",''great''",",''wonderful''",",''awesome''",",''fantastic''",",''beautiful''",",''perfect''",",''terrific''"};
for(int i=1;i<=1000000;i++){
int index =(int)(Math.random()*str_.length);
prepared_stmt.setInt(1, i);
prepared_stmt.setString(2, "10");
prepared_stmt.setString(3, "8");
prepared_stmt.setInt(4, i);
prepared_stmt.setString(5, str_[index]);
prepared_stmt.setString(6, "1");
prepared_stmt.addBatch();
if(i%1000==0){
prepared_stmt.executeBatch();
conn.commit();
System.out.println("正在执行第"+i+"条记录！");
}
}
prepared_stmt.close();
}else if(stmt_type==2){
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String base_sql="insert into IVR_MENU_INFO (IVR_MENU_ID,CALLER_NUMBER,CALLED_NUMBER,SSP_ID,IVR_MENU_TYPE_CODE,CHANGE_CHOICE) values (";
String str[]={",''good''",",''great''",",''wonderful''",",''awesome''",",''fantastic''",",''beautiful''",",''perfect''",",''terrific''"};
for(int i=1;i<=5000000;i++){
String insert_sql="";
int index =(int)(Math.random()*str.length);
insert_sql=base_sql+i+",''10''"+",''8'',"+i+str[index]+",''1'')";
stmt.addBatch(insert_sql);
if(i%1000==0){
stmt.executeBatch();
conn.commit();
System.out.println("正在执行第"+i+"条记录！");
}
}
stmt.close();
}
System.out.println("开始时间："+start_time);
System.out.println("结束时间："+System.currentTimeMillis());
conn.close();
}
catch(Exception e)
{
out.println(e);
}
【JDBC 连接 oracle】
/** JDBC connect to Oracle **/
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.190.***:1521:****";
String user="G12ETEST";
String password="test123";
Connection conn= DriverManager.getConnection(url,user,password);
conn.setAutoCommit(false);
/**
161.80 seconds produce 1000,000 records by useing PreparedStatement class when bachnum is 1000;
101.05 seconds produce 1000,000 records by useing PreparedStatement class when bachnum is 10000;
110.84 seconds produce 1000,000 records by useing PreparedStatement class when bachnum is 50000;
207.16 seconds produce 1000,000 records by useing PreparedStatement class when bachnum is 100000;
**/
long start_time = System.currentTimeMillis();
int stmt_type=1;
if (stmt_type==1)
{
String base_sql_prepared="insert into IVR_MENU_INFO (IVR_MENU_ID,CALLER_NUMBER,CALLED_NUMBER,SSP_ID,IVR_MENU_TYPE_CODE,CHANGE_CHOICE)"
+"values (?,?,?,?,?,?)";
PreparedStatement insertStat = conn.prepareStatement(base_sql_prepared);
String str_[]={"good","great","wonderful","awesome","fantastic","beautiful","perfect","terrific"};
for(int i=1;i<=1000000;i++){
int index =(int)(Math.random()*str_.length);
insertStat.setInt(1, i);
insertStat.setString(2, "10");
insertStat.setString(3, "8");
insertStat.setInt(4, i);
insertStat.setString(5, str_[index]);
insertStat.setString(6, "1");
insertStat.addBatch();
if(i%100000==0){
insertStat.executeBatch();
conn.commit();
System.out.println("正在执行第"+i+"条记录！");
}
}
insertStat.close();
}else if(stmt_type==2){
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String base_sql="insert into IVR_MENU_INFO (IVR_MENU_ID,CALLER_NUMBER,CALLED_NUMBER,SSP_ID,IVR_MENU_TYPE_CODE,CHANGE_CHOICE) values (";
String str[]={",''good''",",''great''",",''wonderful''",",''awesome''",",''fantastic''",",''beautiful''",",''perfect''",",''terrific''"};
for(int i=1;i<=5000000;i++){
String insert_sql="";
int index =(int)(Math.random()*str.length);
insert_sql=base_sql+i+",''10''"+",''8'',"+i+str[index]+",''1'')";
stmt.addBatch(insert_sql);
if(i%1000==0){
stmt.executeBatch();
conn.commit();
System.out.println("正在执行第"+i+"条记录！");
}
}
stmt.close();
}
System.out.println("开始时间："+start_time);
System.out.println("结束时间："+System.currentTimeMillis());
conn.close();
}
catch(Exception e)
{
out.println(e);
}
【参考网址】
sqlserver数据库驱动包sqljdbc.jar
https://docs.microsoft.com/zh-cn/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15
![JSP连接MySql/MS SQL Server/Oracle数据库连接方法[整理]](http://www.gvkun.com/zb_users/upload/2025/03/4a6dac8d-68b8-4588-8f04-d437322aa1d31741601426273.jpg "JSP连接MySql/MS SQL Server/Oracle数据库连接方法[整理]")
JSP连接MySql/MS SQL Server/Oracle数据库连接方法[整理]
这个经常整理更新
JSP连接MysqL数据库方法
首先先将MysqL的数据库连接驱动拷贝到Tomcat/common/lib包下
下载mysql-connector-java-5.1.6.zip
http://MysqL.cs.pu.edu.tw/Downloads/connector-j/mysql-connector-java-5.1.6.zip
配置Tomcat的虚拟目录-略
创建jdbcMysqL.jsp页面
页面代码如下：
复制代码 代码如下:
final String MysqLDBDRIVER="org.gjt.mm.MysqL.Driver";
final String MysqLDBURL="jdbc:MysqL://localhost/mldn";
final String MysqLDBUSER="root";
final String MysqLDBUSERPASS="root";
Connection con = null;
%>
try{
Class.forName(MysqLDBDRIVER);
con = DriverManager.getConnection(MysqLDBURL,MysqLDBUSER,MysqLDBUSERPASS);
Statement stmt = con.createStatement();
String sql ="create table jobs(name varchar(32))";
//执行创建语句
stmt.executeUpdate(sql);
out.println("连接成功！");
stmt.close();
}catch(Exception e){
out.println(e);
}
%>
启动Tomcat
地址栏输入：http://localhost:8080/Demo/jdbcMysqL.jsp
测试数据连接成功！
验证数据库
验证成功！
-----连接MS sql Server/Oracle的方法待续
今天关于servlet连接mysql数据库和oracle数据库和servlet与数据库连接的分享就到这里，希望大家有所收获，若想了解更多关于html文件form表单action调用servlet连接mysql数据库实例、java实现的连接oracle/mysql数据库功能简单示例【附oracle+mysql数据库驱动包】、JDBC连接mysql、sqlserver、oracle数据库示例，含代码、JSP连接MySql/MS SQL Server/Oracle数据库连接方法[整理]等相关知识，可以在本站进行查询。
本文标签：
![[转帖]Ubuntu 安装 Wine方法（ubuntu如何安装wine）](https://www.gvkun.com/zb_users/cache/thumbs/4c83df0e2303284d68480d1b1378581d-180-120-1.jpg)
