下面是我写的MYsql连接程序,不知道对不对,
我就是想要用这个程序在jsp网页里连接数据
那位大哥帮我看看对不对
还有应该怎么编译
先谢谢le !!!package myhop;import java.io.PrintStream;
import java.sql.*;
import javax.swing.text.*;
import java.awt.*;
import javax.swing.*;
import java.util.*;
import java.io.*;public final class DBMysqlConnection {
private Connection conn = null; //连接对象
private Statement st; //语句对象
private ResultSet rs; //结果集对象
private String driverName = "com.mysql.jdbc.Driver";
private String userName = "root";
private String userPwd = "19860326";
private String dbName = "myshop";
private String url = "jdbc:mysql://localhost:8080/" + dbname + "?user=" +
userName + "&password=" + userPwd +
"&useUnicode=true&characterEncoding=GB2312" ; public Connection getConnToMySql() { try {
Driver driver = Class.forName("com.mysql.jdbc.Driver").newInstance();
// Class.forName要求JVM查找并加载指定的类,加载驱动程序
DriverManager.registerDriver(driver);
//新加载的 Driver 类都要通过调用 DriverManager.registerDriver 类进行自我注册 conn = DriverManager.getConnection(url);
st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}
catch (Exception ex) {
ex.printStackTrace();
System.out.println("error:forName ") ; }
return conn; }}public ResultSet executeQuery(String sql) { //查询
try {
//st = getConnection().createStatement();
conn = DriverManager.getConnection(url);
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); /***
还有用这个的 BulidCon(); 不知道什么意思
***/
rs = st.executeQuery(sql);
}
catch (SQLException ex) {
ex.printStackTrace();
sqlclose();
}
return rs;
}public void executeUpdate(String sql) { // 更新
try {
//st = getConnection().createStatement();
conn = DriverManager.getConnection(url);
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
st.executeUpdate(sql);
}
catch (SQLException ex) {
ex.printStackTrace();
sqlclose();
}
}public void sqlclose() {
try {
if (rs != null) {
rs.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
}
catch (SQLException ex) {
ex.printStackTrace();
}
}
我就是想要用这个程序在jsp网页里连接数据
那位大哥帮我看看对不对
还有应该怎么编译
先谢谢le !!!package myhop;import java.io.PrintStream;
import java.sql.*;
import javax.swing.text.*;
import java.awt.*;
import javax.swing.*;
import java.util.*;
import java.io.*;public final class DBMysqlConnection {
private Connection conn = null; //连接对象
private Statement st; //语句对象
private ResultSet rs; //结果集对象
private String driverName = "com.mysql.jdbc.Driver";
private String userName = "root";
private String userPwd = "19860326";
private String dbName = "myshop";
private String url = "jdbc:mysql://localhost:8080/" + dbname + "?user=" +
userName + "&password=" + userPwd +
"&useUnicode=true&characterEncoding=GB2312" ; public Connection getConnToMySql() { try {
Driver driver = Class.forName("com.mysql.jdbc.Driver").newInstance();
// Class.forName要求JVM查找并加载指定的类,加载驱动程序
DriverManager.registerDriver(driver);
//新加载的 Driver 类都要通过调用 DriverManager.registerDriver 类进行自我注册 conn = DriverManager.getConnection(url);
st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}
catch (Exception ex) {
ex.printStackTrace();
System.out.println("error:forName ") ; }
return conn; }}public ResultSet executeQuery(String sql) { //查询
try {
//st = getConnection().createStatement();
conn = DriverManager.getConnection(url);
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); /***
还有用这个的 BulidCon(); 不知道什么意思
***/
rs = st.executeQuery(sql);
}
catch (SQLException ex) {
ex.printStackTrace();
sqlclose();
}
return rs;
}public void executeUpdate(String sql) { // 更新
try {
//st = getConnection().createStatement();
conn = DriverManager.getConnection(url);
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
st.executeUpdate(sql);
}
catch (SQLException ex) {
ex.printStackTrace();
sqlclose();
}
}public void sqlclose() {
try {
if (rs != null) {
rs.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
}
catch (SQLException ex) {
ex.printStackTrace();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货