jsp高手请赐教

来源：百度知道 编辑：UC知道 时间：2024/09/21 06:30:37
<%@ page contentType="text/html; charset=gbk" language="java"%>
<%@ page import="java.sql.*" %>
<html>
<head>
<title></title>
<META http-equiv="Content-Type" content="text/html; charset=GBK">
</head>
<body>
<%
String name=request.getParameter("name");
String id=request.getParameter("id");

byte b[]=name.getBytes("ISO-8859-1");
name=new String(b);
Connection con;
Statement sql;
ResultSet rs;

try
{//建立JDBC-ODBC桥驱动程序,用到java.lang包中的类Class,调用其方法forName().
Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
}
catch(ClassNotFoundException e){}

try
{//创建连接对象con,它属于Connection类,然后用类DriverManager调用getConnection()

<%@ page contentType="text/html; charset=gbk" language="java"%>
<%@ page import="java.sql.*" %>
<html>
<head>
<title></title>
<META http-equiv="Content-Type" content="text/html; charset=GBK">
</head>
<body>
<%
String name=request.getParameter("name");
String id=request.getParameter("id");

byte b[]=name.getBytes("ISO-8859-1");
name=new String(b);
Connection con;
Statement sql;
ResultSet rs;

try
{
//建立JDBC-ODBC桥驱动程序,用到java.lang包中的类Class,调用其方法forName().
Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();

//创建连接对象con,它属于Connection类,然后用类DriverManager调用getConnection()
con=DriverManager.getConnection("jdbc:sybase:Tds:156.56.16.37:5000/hzts","sa","houset");