请帮解释这些jsp与ODBC的连接代码
来源:百度知道 编辑:UC知道 时间:2024/05/25 18:33:48
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<% try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch(Exception e) {
out.print("数据库驱动加载失败!!!");
}
%>
<%
Connection conn = null;
String dbDriver = "jdbc:odbc:test";
try {
conn = DriverManager.getConnection(dbDriver);
} catch(Exception e) {
out.print("数据库连接失败!!");
}
%><%
Statement stmt = null;
String sql = "update huyuan set name = 'xxxdd', password = 'khdff124' where id = 4";
try {
stmt = conn.createStatement();
stmt.executeUpdate(sql);
} catch(Exception e) {
out.print("数据库插入失败!!");
}
%>
<%
try {
stmt.close();
conn.close();
} catch(Exception ex) {
好久没用JDBC了这是我以前的代码这里使用的是MYSQL,不明白你为什么要在jsp中写java代码呢?还是分开来写吧:
package Mhong;
import java.sql.*;
import java.util.*;
public class Mshujuku {
Connection conn=null;
PreparedStatement st=null;
ResultSet re=null;
//连接数据库,注意这里使用的是mysql,必须保证驱动已经成功导入
public Connection getconnection()
{
try {
Class.forName("com.mysql.jdbc.Driver");
try {
conn=DriverManager.getConnection("jdbc:mysql://loc" +
"alhost:3306/hongfengye","root","123");
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
//关闭的方法
public void close()
{
if(st!=null)
{
try {
st.close();
} catch (SQLException e) {
e.print