先写一个连接bean或连接文件,然后在jsp页面通过写好的bean或连接文件 连接数据库!
<%
//数据库连接
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jck;charset=gb2312","sa","123");
Statement stmt=con.createStatement();
Statement stmt1=con.createStatement();
%>
<%
String sql="select from ";
ResultSet rs=stmt.executeQuery(sql); String ss =rs.getString("aa");
out.print(ss);%>
你也可以通过bean来实现,资料有很多,这里就不详说了!
<%
//数据库连接
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jck;charset=gb2312","sa","123");
Statement stmt=con.createStatement();
Statement stmt1=con.createStatement();
%>
<%
String sql="select from ";
ResultSet rs=stmt.executeQuery(sql); String ss =rs.getString("aa");
out.print(ss);%>
你也可以通过bean来实现,资料有很多,这里就不详说了!
把sqlserver导出到mysql中
最好能直接从sqlserver导入到mysql
package bean;import java.sql.*;public class BeanBean
{
public String query_statement;
public ResultSet result=null;
public Connection conn = null;
public PreparedStatement stmt = null ; public void setQuerystatement(String query_statement)
{
this.query_statement=query_statement;
}
public void setConnection() throws Exception
{
Connection conn1;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn1=DriverManager.getConnection("jdbc:oracle:thin:@192.1.1.170:1521:njagent","calldb","ebis");
conn1.setAutoCommit(false);
this.conn = conn1;
}
/*获取查询结果*/
public ResultSet getResult()
{
try
{
stmt=conn.prepareStatement(query_statement,java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
result=stmt.executeQuery();
}catch(Exception e){System.out.println(e);}
return result;
} /*对数据库进行增加记录操作*/
public void insertRecord() throws SQLException,java.io.UnsupportedEncodingException
{
try
{
stmt=conn.prepareStatement(query_statement);
stmt.executeUpdate();
stmt.close();
conn.commit();
}
catch(Exception e)
{
System.out.println(e);
conn.rollback();
}
} /*对数据记录进行更改操作*/
public void updateRecord() throws SQLException,java.io.UnsupportedEncodingException
{
try
{
stmt=conn.prepareStatement(query_statement);
stmt.executeUpdate();
stmt.close();
conn.commit();
}
catch(Exception e)
{
System.out.println(e);
conn.rollback();
}
}
/*删除数据记录*/
public void deleteRecord() throws SQLException,java.io.UnsupportedEncodingException
{
try
{
stmt=conn.prepareStatement(query_statement);
stmt.executeUpdate();
stmt.close();
conn.commit();
}
catch(Exception e)
{
System.out.println(e);
conn.rollback();
}
}
/*关闭数据库*/
public void close() throws SQLException{
if(conn != null) conn.close();
if(stmt != null) stmt.close();
}
}JSP页面如下<%@ page contentType="text/html" import="bean.*,java.sql.*,java.lang.String" %>
<jsp:useBean id="BeanID" scope="request" class="bean.BeanBean" />
<%
ResultSet rst = null;
bean.BeanBean sBean = new bean.BeanBean();
sBean.setConnection();
try{
sBean.setQuerystatement("select yewu_id from yewu_index");
rst=sBean.getResult();
}catch(Exception e){System.out.println(e); }
if (rst != null){
while (rst.next()){%><%=rst.getString(1)%><%}
}
sBean.close();
%>
不过也谢谢了