package com.lyq.controller; import java.io.IOException; import java.sql.DriverManager; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;import com.mysql.jdbc.Connection; import com.mysql.jdbc.Statement;public class MySQLBasic extends HttpServlet { /** * */ private static final long serialVersionUID = 3237431001136604871L; @Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { Connection connection = null;
Statement stmt = null;
//ResultSet rs = null;
String sql = null;
try {
/*****填写数据库相关信息(请查找数据库详情页)*****/
String databaseName = "mSxxxxxxxxxxxlnsrH";
String host = "sqld.duapp.com";
String port = "4050";
String username = "xxxxxxxxx"; //用户AK
//String username = BAEHelper.getBaeEnv("BAE_ENV_AK");
String password = “xxxxxxxxxxxxx"; //用户SK
//String password = BAEHelper.getBaeEnv("BAE_ENV_SK");
String driverName = "com.mysql.jdbc.Driver";
String dbUrl = "jdbc:mysql://";
String serverName = host + ":" + port + "/";
String connName = dbUrl + serverName + databaseName;
/******接着连接并选择数据库名为databaseName的服务器******/
Class.forName(driverName).newInstance();
connection = (Connection) DriverManager.getConnection(connName, username, password); stmt = (Statement) connection.createStatement();
/******至此连接已完全建立,就可对当前数据库进行相应的操作了*****/
/******接下来就可以使用其它标准mysql函数操作进行数据库操作*****/
//创建一个数据库表
sql = "create table if not exists test_mysql(" + "id int primary key auto_increment," + "no int, " + "name varchar(1024)," + "key idx_no(no))"; stmt.execute(sql); } catch (Exception e) { e.printStackTrace(resp.getWriter()); } } }