有表啊,用下面语句可以读出数据:
<%
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
url = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName = guestbook";
conn = DriverManager.getConnection(url, "admin", "aaasds"); //establish the connection to the server;
stmt = conn.createStatement();
sql = "select * from MESSAGE";
rs = stmt.executeQuery(sql);
while(rs.next())
{
%>
<%
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
url = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName = guestbook";
conn = DriverManager.getConnection(url, "admin", "aaasds"); //establish the connection to the server;
stmt = conn.createStatement();
sql = "select * from MESSAGE";
rs = stmt.executeQuery(sql);
while(rs.next())
{
%>
加个条件,如
sql = "INSERT INTO MESSAGE VALUES('7', 'SSS','STRS') where id =null";
<%
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
url = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName = guestbook";
conn = DriverManager.getConnection(url, "sa", "aaasds"); //establish the connection to the server;
stmt = conn.createStatement();
sql = "INSERT INTO MESSAGE (ID, TITLE, TEXT) VALUES('7', 'SSS','STRS')";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println(e);
}
%>
数据库里面就是ID,TITLE,TEXT三个字段,好奇怪啊
那种方法也不行啊
附上解决问题的网址,希望其他有一样问题的朋友能够解决:
http://www.daima.com.cn/Info/67/Info43397/