这是我的程序,连接数据库成功,并且单数run可以在控制台显示数据库数据
现在想通过tomcat把数据库数据发布到网上,这个如何办到呢。打架有相关代码或者教程吗
这是我的连接程序:直接发布到tomcat上,DOS没有错误,网页显示找不到
package MyTest;
import java.sql.*;
import java.util.List;
public class Main {
static String Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
static String Url = "jdbc:sqlserver://localhost:1433;datebaseName=Mine";
static String User = "sa";
static String Password = "12345";
static Connection conn = null;
public static void main(String[] args) {
try {
Class.forName(Driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(Url, User, Password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
Statement sm = conn.createStatement();
String sql = "select * from student";
ResultSet rs = sm.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
}
//renderJson(list);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}