Conncetion con=null;
Statement sql=null;
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{}
try{
con=DriveManager.getConnection("jdbc:odbc:sun","username","password");
sql=con.createStatement();
Statement sql=null;
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{}
try{
con=DriveManager.getConnection("jdbc:odbc:sun","username","password");
sql=con.createStatement();
解决方案 »
- 保存信息时将文字信息转换为.txt格式
- ssh框架中,PO数据传递的问题
- 有个myeclipse问题,我忘记是哪个菜单选项了!
- jtable问题,来大牛解决了啊【急求】分不是问题
- 哪儿能下载到j2ee.jar对应的源码?
- 提取中文拼音缩写
- 谁能发给我一份ejbcreate(小章) 发表的jsp树型结构示例(jsp+weblogic+oracle)例子的打包,100分
- struts乱码
- 哪里可以找到纯JAVA的电子书店代码
- Spring AOP中doThrowing()始终不执行
- jbuilder+weblogic,利用jspsmartupload实现文件上传,jspsmartupload放在什么地方?
- 请教怎么学Applet的问题!100分!!!
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=haha";
String user="haha_f";
String password="testjsp";
Connection conn=DriverManager.getConnection(url,user,password);
//Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE.ResultSet.CONCUR_UPDATABLE);
Statement stmt=conn.createStatement();
String sql="select * from jiveID";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){%>
字段1:<%=rs.getString(1)%><br>
字段2:<%=rs.getString(2)%><br>
字段3:<%=rs.getString(3)%><br>
字段4:<%=rs.getString(4)%><br>
字段5:<%=rs.getString(5)%><br><br>
<%}%>
<%out.print("JSP连接MSSQL数据库操作成功了!哈哈哈!!!");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
<html>
<head>
<title>
jsp
</title>
</head>
<body>
<%@ page language="java" import="java.sql.*"%>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection conn=DriverManager.getConnection("jdbc:oralce:thin:@127.0.0.1:1521:TEST","SYSTEM","MANAGER");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from kd_order");
while(rs.next())
{
%>
<%=rs.getString(1)%>
<%=rs.getString(2)%>
<%=rs.getString(3)%>
<%
}
%>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
mssqlserver.jar
msutil.jar
搜一下!