|
|
|
|
|
|
复制本帖HTML代码
|
|
高亮:
今天贴
X 昨天贴
X 前天贴
X |
的数据源及其权限
<%@ page import = "java.sql.*" %>
<%
String url = "jdbc:odbc:mysql";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
try{
Class.forName(driver);
java.sql.Connection conn = DriverManager.getConnection(url,"wushilin","******");
Statement s = conn.createStatement();
s.executeUpdate("insert into test values('asdf')");
ResultSet rs = s.executeQuery("select * from test");
while(rs.next())
{
out.println(rs.getString(1)+"<br>");
}
rs.close();
s.close();
conn.close();
}
catch(Exception e)
{
System.err.println("Error");
}
%>
output：
test
test
test
asdf
asdf
asdf
asdf
.
|
| 欢迎来到华新中文网，踊跃发帖是支持我们的最好方法! |
|
|
